Tuesday, February 14, 2012

backup

I am not a sql server DBA, so please be gentle.
To se tthe scene. We are using hardware plication , and point in time copy
technolgoy for backup (EMC SRDF for rpelication, and Business Copies for
Backup). For backup we shut the DB down, split the BC Disk, mount that disk
to a backup server, and then start the SQL DB up.
Bearing this in mind is it possible to roll forward/backup using the logs,
post a restore proceedure? Is it possible to get back to a point in time
during the day when the DB may of corrupted, or lost data? I know I can get
back to the point when the Business Copy was taken, but unsure of the
flexability within SQL 2000. I know this is possible on Oracle DB's.Disregarding the SAN for a moment:
In SQL Server you basically have a database backup (full backup) and transac
tion log backups (backup
of changes). When you restore, you do the most recent db backup and then the
subsequent log backups-
For a log backup, you have a STOPAT parameter to stop at desired time.
What you need is for your SAN to communicate that a snapshot is taken to SQL
Server so that SQL
server considers this a db backup. Because this will allow you to do log bac
kups. So you can now use
the db backup (which really is a snapshot) and then apply the log backups wi
th above mentioned
STOPAT.
Ask your SAN vendor for SQL Server support, and this is most probably suppor
ted as a "VDI device"
(SQL Server terminology).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"visaya" <visaya@.discussions.microsoft.com> wrote in message
news:55E2C2D4-509B-429B-9C38-5CDD5D5CB111@.microsoft.com...
>I am not a sql server DBA, so please be gentle.
> To se tthe scene. We are using hardware plication , and point in time copy
> technolgoy for backup (EMC SRDF for rpelication, and Business Copies for
> Backup). For backup we shut the DB down, split the BC Disk, mount that dis
k
> to a backup server, and then start the SQL DB up.
> Bearing this in mind is it possible to roll forward/backup using the logs,
> post a restore proceedure? Is it possible to get back to a point in time
> during the day when the DB may of corrupted, or lost data? I know I can ge
t
> back to the point when the Business Copy was taken, but unsure of the
> flexability within SQL 2000. I know this is possible on Oracle DB's.|||Tibor
Thanks, so just to clarify;
If, using EMC, I use Replciationm Manager (and this does do SQL support), in
a restore I would do dthe following.
Stop the DB
Use my BC, and reverse merge back to the original DATA disk. (please bear in
mind that the data, and logs are on different disk, and BCs)
Use my LOGS BV to replay the logs woth the STOPAT parameter? This would get
me back to a point in time?
"Tibor Karaszi" wrote:

> Disregarding the SAN for a moment:
> In SQL Server you basically have a database backup (full backup) and trans
action log backups (backup
> of changes). When you restore, you do the most recent db backup and then t
he subsequent log backups-
> For a log backup, you have a STOPAT parameter to stop at desired time.
> What you need is for your SAN to communicate that a snapshot is taken to S
QL Server so that SQL
> server considers this a db backup. Because this will allow you to do log b
ackups. So you can now use
> the db backup (which really is a snapshot) and then apply the log backups
with above mentioned
> STOPAT.
> Ask your SAN vendor for SQL Server support, and this is most probably supp
orted as a "VDI device"
> (SQL Server terminology).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "visaya" <visaya@.discussions.microsoft.com> wrote in message
> news:55E2C2D4-509B-429B-9C38-5CDD5D5CB111@.microsoft.com...
>
>|||You have to read the documentation with your SAN for how to do restore. Or p
erhaps someone who have
used those products might jump in here.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"visaya" <visaya@.discussions.microsoft.com> wrote in message
news:EF560F6D-0E77-40D9-AD51-1EB853ABE6BF@.microsoft.com...[vbcol=seagreen]
> Tibor
> Thanks, so just to clarify;
> If, using EMC, I use Replciationm Manager (and this does do SQL support),
in
> a restore I would do dthe following.
> Stop the DB
> Use my BC, and reverse merge back to the original DATA disk. (please bear
in
> mind that the data, and logs are on different disk, and BCs)
> Use my LOGS BV to replay the logs woth the STOPAT parameter? This would ge
t
> me back to a point in time?
> "Tibor Karaszi" wrote:
>

No comments:

Post a Comment