August 21, 2012 at 9:13 am
Hi,
How can I change a file gorup for a specific file name?
The issue that I'm having is that I already have a live/production database and I want to change one of the file names to a different filegroup.
For example:
Logical Name FileGroup File Name
DB DB DB.MDF
DB1 DB1 DB_1.NDF
DB2 DB2 DB_2.NDF
DB3 DB3 DB_3.NDF
DB4 DB3 DB_4.NDF
Change File Name or Logical Name DB4 from DB3 to DB4:
Logical Name FileGroup File Name
DB DB DB.MDF
DB1 DB1 DB_1.NDF
DB2 DB2 DB_2.NDF
DB3 DB3 DB_3.NDF
DB4 DB4 DB_4.NDF
August 21, 2012 at 9:14 am
This a duplicate and can be deleted.
August 21, 2012 at 9:15 am
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1347848-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply