October 7, 2010 at 3:12 pm
what is best option in moving .mdf data file from G:\SQLDB\dbname.mdf file
to H:\SQLDB
October 7, 2010 at 3:37 pm
sp_dettach and sp_attach are the favorites of most people that don't like to use the GUI.
Sorry that would be sp_detach_db and sp_attach_db
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 7, 2010 at 4:26 pm
The recommended method is now:
1) Alter Database {db} Modify File (Name = logical_name, filename = 'new pathame');
2) Alter Database {db} Set Offline With rollback immediate;
3) Copy files to new location
4) Alter Database {db} Set Online;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 8, 2010 at 8:55 am
Jeffrey Williams-493691 (10/7/2010)
The recommended method is now:1) Alter Database {db} Modify File (Name = logical_name, filename = 'new pathame');
2) Alter Database {db} Set Offline With rollback immediate;
3) Copy files to new location
4) Alter Database {db} Set Online;
This is SQL Server 2000, or at least that is the forum the OP put it in 🙂
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 8, 2010 at 1:34 pm
Shawn, yes - I didn't see that. Thanks.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply