Monday, June 4, 2012

Change Lync Database default path

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

No comments:

Post a Comment