Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring a backup into another database
Message
 
 
To
01/09/2010 21:42:56
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01479690
Message ID:
01479749
Views:
31
>>I don't see an option to not restore them as well when I try it in SSMS.
>
>Exactly, the only way would be to change the name of all the destinations. But, I ran out of space. So, I am making room now and will see how it goes.

I asked this question to one of my DBA friends to be sure. The answer is No, you can not remove NDF file when restoring.


There are ways to remove an empty .ndf file :
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/9519/Remove-secondary-ndf-file
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform