Tuesday, September 09, 2008

Attaching .mdf files in Sql Server when you dont have a .ldf file

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