February 2, 2010 at 12:04 pm
i dont know much about sql server 2005. i want to attach a .ndf file which is taken from the backup with sql script. Is it possible. if so then how??
February 2, 2010 at 5:09 pm
This link will show you how to do that.
http://msdn.microsoft.com/en-us/library/ms190255.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 2, 2010 at 5:22 pm
I don't believe you can do this with the mdf as well.
February 2, 2010 at 5:27 pm
The mdf will need to be restored as Steve suggested.
One other possibility is piecemeal restores - if your database is segmented into filegroups.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply