This is one of the major topic which i faced lot of issues.I tried multiple time to create databse using install-csdatabase command but it always create database its on logic.not wher you want.So after lot of study i found a solution and moved databse in to proper disks where i required.
Here in my case most of the databses created in C drive.I wanted create in E drive.Find the below steps how i achived the same.
Logon to SQL server
Open SQL managemnet Studio
Click on New Query
Follow the Steps Below
Example:-
rtccab
Note down the database path
use rtcab
go
sp_helpfile
go
C:\CsData\ABSStore\(default)\dbpath\rtcab.mdf
c:\csdata\absstore\(default)\logpath\rtcab.ldf
Detatch the databse
use master
go
sp_detach_db 'rtcab'
go
Copy physical file into new location
Attatch DB
use master
go
sp_attach_db 'rtcab','E:\CsData\ABSStore\(default)\dbpath\rtcab.mdf','E:\csdata\absstore\(default)\logpath\rtcab.ldf'
go
Same way follow for all database
Here in my case most of the databses created in C drive.I wanted create in E drive.Find the below steps how i achived the same.
Logon to SQL server
Open SQL managemnet Studio
Click on New Query
Follow the Steps Below
Example:-
rtccab
Note down the database path
use rtcab
go
sp_helpfile
go
C:\CsData\ABSStore\(default)\dbpath\rtcab.mdf
c:\csdata\absstore\(default)\logpath\rtcab.ldf
Detatch the databse
use master
go
sp_detach_db 'rtcab'
go
Copy physical file into new location
Attatch DB
use master
go
sp_attach_db 'rtcab','E:\CsData\ABSStore\(default)\dbpath\rtcab.mdf','E:\csdata\absstore\(default)\logpath\rtcab.ldf'
go
Same way follow for all database
No comments:
Post a Comment