Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving a filegroup into another location
Message
 
 
To
30/03/2011 00:51:14
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01505453
Message ID:
01505454
Views:
29
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform