Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restoring a backup into another database
Message
 
 
À
01/09/2010 21:42:56
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01479690
Message ID:
01479749
Vues:
32
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform