Hi today i was trying to attach an .mdf file which was not having the .ldf file with it, sql server was giving error with it but later i found a workaround.
So to attach a .mdf file without its .ldf file just press remove button at the creation windows in your sql server management studio.
It will remove the .ldf file location and create a new .ldf file for your database.
Here is a link of how to do this.
http://img.photobucket.com/albums/v472/Schmedrick/attach.gif
0 comments :
Post a Comment