I would like to create a standby database without backup restore.
We currently have a continous access storage ( disk duplication)but I would like to change to logshipping instead.
The database is 1 TB large and backup and restoring would take at least 2 days.
And we already have the datafile duplicated , soI would like to use these datafiles.
How can this be done?
Have you tried to issue:
BACKUP DATABASE <mydatabase> WITH NORECOVERY
This will place the database in a recovering state where you can apply transaction logs, as long as you have log backups which contain the next LSN needing to be applied.
No comments:
Post a Comment