Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Move the datafiles from a readonly/standby databas

Author  Topic 

csaha
Yak Posting Veteran

52 Posts

Posted - 2012-11-30 : 14:34:59
I have enabled log shipping in primary server. Readonly/standby database is created in the secondary server however the datafiles and logfiles are created in the default location: c:Program FilesMicrosoft SQL Server....MSSQLData. Can I move the datafiles to a different location like D:Data while the database is in readonly/Standby mode. However after I enable logshipping and execute the following command in secondary server, it states that the data is in D:Data use [AbraHRMS_Live] go sp_helpfile go

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-30 : 14:38:13
You would need to restore it to that location and get log shipping back in sync.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -