|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 11/30/2012 : 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 |
|
Move the datafiles from a readonly/standby databas
