Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving a filegroup into another location
Message
 
 
À
30/03/2011 00:51:14
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:
01505454
Vues:
30
>It seems to be very difficult to move a filegroup into another location. I am making reference to the Path column in the database properties under the Files section. Has anyone found a clean way to do that?

See http://msdn.microsoft.com/en-us/library/bb522469.aspx

and there
To move a data file or log file to a new location, specify the current logical file name in the NAME clause and specify the new path and operating system file name in the FILENAME clause. For example:

Copy
MODIFY FILE ( NAME = logical_file_name, FILENAME = ' new_path/os_file_name ' )
When you move a full-text catalog, specify only the new path in the FILENAME clause. Do not specify the operating-system file name.

For more information, see Moving Database Files.
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