Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 error while restoring .bak

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2011-05-19 : 02:16:24
Hi,
I took a backup of my databse in the .bak format.that bak files includes .mdf,.ndf,and .ldf. while restoring .bak files, i'm getting error regarding .ndf files. can u tell me how to restore .ndf files.
previously i used to restored .mdf and .ldf. but i dont know how to restore .ndf. plz let me know the way.

thanks.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-19 : 03:29:45
Exactly the same way you do with the mdf and ldf, there's no difference between the syntax (assuming MOVE) for the file types

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -