when we installed our SAP in BW dev server we put BW DATAFILE and LOGFILE in E drive. and our BW DEV and QAS is in one server. now our E drive running low disk space. so we need to transfer these files to other drive. we are using SQL Server 2000 . i follow the below procedure for transfering the files.
Detach the database as follows:
use master go sp_detach_db 'BWD' go
Next, copy the data files and the log files from the current location (D:\Mssql7\Data) to the new location (E:\Sqldata).
Re-attach the database. Point to the files in the new location as follows:
use master go sp_attach_db 'BWD','E:\BWDDATA1\BWDDATA1.mdf', 'E:\BWDDATA2\BWDDATA2.ndf', 'F:\BWDDATA3\BWDDATA3.ndf', 'E:\BWDLOG1\BWDLOG1.ldf', 'E:\BWDLOG2\BWDLOG2.ldf'
go
Verify the change in file locations by using the sp_helpfile stored procedure:
use BWD go sp_helpfile go
The filename column values should reflect the new locations.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.