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.
| 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 |
|
|
|
|
|
Move the datafiles from a readonly/standby databas