Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving a filegroup into another location
Message
De
30/03/2011 09:20:36
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01505453
Message ID:
01505502
Vues:
31
>It's described in details in BOL Moving User Databases

Thanks for the reference

When I executed the command for 16 files to be moved last night, I got confirmed that the change was done and would be in effect on the restart. That, of course, assumes that I stop the server, move the files and restart the server. As this was a big copy, I let it run overnight. Then, I started the server this morning. I verified on the disk and was able to see that 16 files were moved at the proper location. So, I tried to removed the old ones. For some it didn't work as a lock was still on them. So, I went into SSMS and into the database properties. I was surprise to see that some of them are still pointing to the old directory. I just do not know how to resolve that issue now.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform