Recovery Manager for SQL - backup solution needed
Posted: Wed May 14, 2014 6:31 am
Okay wondered if anyone on here had similar problems and had come up with a solution.
RMSQL is painful, it basically manages either a snapshot or a remote copy. Remote copies not done in synchronous mode are deleted at the local site (give me strength).
So what do I expect from a tool.
I expect to be able to do snapshots and manage them at either site.
Is this possible ? 'not really'
I need to be able to do point in time restores. This means I can only snapshot once in a day (snapshot will break the log chain !) RMS SQL has no awareness of Transaction logs, so I need to initiate a copy them to our Remote location after log backup job completion.
Im trying to achieve this:
I would like to be able to hold 3 days local and remotely (and not be in synchronous mode as I don't have the links to move the data at speed during the day.)
I need to be able to mount the latest consistent snapshot and DBCC the database at our Remote site
I need to be able to mount the latest consistent snapshot and send it to backup tape.
I need to be able to do a point in time restore at either site for x days.
I need to be able to initiate the job from SQL agent, most dba's run jobs to look after indexes and stats. not been able to link this with the backup job is a pain in the rear.
Above all snapshot is required as I cant afford to wait for the 2tb + databases to run manual backup jobs.
Has anyone come up with any solutions to this?
RMSQL is painful, it basically manages either a snapshot or a remote copy. Remote copies not done in synchronous mode are deleted at the local site (give me strength).
So what do I expect from a tool.
I expect to be able to do snapshots and manage them at either site.
Is this possible ? 'not really'
I need to be able to do point in time restores. This means I can only snapshot once in a day (snapshot will break the log chain !) RMS SQL has no awareness of Transaction logs, so I need to initiate a copy them to our Remote location after log backup job completion.
Im trying to achieve this:
I would like to be able to hold 3 days local and remotely (and not be in synchronous mode as I don't have the links to move the data at speed during the day.)
I need to be able to mount the latest consistent snapshot and DBCC the database at our Remote site
I need to be able to mount the latest consistent snapshot and send it to backup tape.
I need to be able to do a point in time restore at either site for x days.
I need to be able to initiate the job from SQL agent, most dba's run jobs to look after indexes and stats. not been able to link this with the backup job is a pain in the rear.
Above all snapshot is required as I cant afford to wait for the 2tb + databases to run manual backup jobs.
Has anyone come up with any solutions to this?