I have a DB01 originally residing on c:\Data together with it's log file. But the c: drive is becoming full. I've to move it to d:\Data . How should I do this? thanks! Please visit my WebCam!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
procedure of physical location of DB
- Thread starter hmcheung
- Start date
Bernadette
MIS
Hi There
1 You could back up the existing database.
2 Create a new database on D:\data
3 Restore the existing database to the new DB on D:\data
4 Delete the old database Hope This Helps
Bernadette
1 You could back up the existing database.
2 Create a new database on D:\data
3 Restore the existing database to the new DB on D:\data
4 Delete the old database Hope This Helps
Bernadette
Cagliostro
Programmer
Hi,
Better is to detach database
--
EXEC sp_detach_db 'Your Database'
--
after it copy youdatabase_data.mdf to your new location
the last step is to attach it
--
EXEC sp_attach_single_file_db @dbname = 'YouDatabase',
@physname = 'NewPath\youdatabase_data.mdf'
--
John Fill
Better is to detach database
--
EXEC sp_detach_db 'Your Database'
--
after it copy youdatabase_data.mdf to your new location
the last step is to attach it
--
EXEC sp_attach_single_file_db @dbname = 'YouDatabase',
@physname = 'NewPath\youdatabase_data.mdf'
--
John Fill
- Status
Similar threads
- Locked
- Question