Hello,
I have a question regarding SQL Server disaster recovery plan.
Lets say I backup quite regularily master, msdb, model and my
databases.
Is it enough to recover everything in case of dissaster? (I am
concerned about the SQL logins and users).
Lets say I have SQL login that maps to a Windows domain user.
Lets say the AD has to be restored.
After my SQL restauration (master, msdb, my databases) the logins in
SQL Server will they be OK?
Also another question regarding the backup.
A database full backup does not truncate the log.
I guess the log knows via a LSN mechanism that the full backup took
place and when the database full backup is restored followed by a Log
restauration from the LOG backup only the new (after the full backup)
will be restored.
Please confirm.
Any input is highly appreciated.
Carly
Hi Carly
"Carly" wrote:
> Hello,
> I have a question regarding SQL Server disaster recovery plan.
> Lets say I backup quite regularily master, msdb, model and my
> databases.
> Is it enough to recover everything in case of dissaster? (I am
> concerned about the SQL logins and users).
> Lets say I have SQL login that maps to a Windows domain user.
> Lets say the AD has to be restored.
> After my SQL restauration (master, msdb, my databases) the logins in
> SQL Server will they be OK?
Restoring the Master database will restore the logins, so long as the
machine/domain are the same as the original server you should be ok. You may
also want to periodically script the recreating of the logins as a fall back
see http://support.microsoft.com/default.aspx/kb/246133/
> Also another question regarding the backup.
> A database full backup does not truncate the log.
> I guess the log knows via a LSN mechanism that the full backup took
> place and when the database full backup is restored followed by a Log
> restauration from the LOG backup only the new (after the full backup)
> will be restored.
> Please confirm.
Information on transaction log backups can be found at
http://msdn2.microsoft.com/en-us/library/aa173551(SQL.80).aspx
If you recover to a point in time only the committed transactions up to that
point in time will be recovered
http://msdn2.microsoft.com/en-us/library/aa196441(SQL.80).aspx#
For disaster recovery you will need to have a checklist of what the
requirements are for your scenario and how you fulfill them, and the
process(es) you need to recover from it. Once you have listed these for all
your possible scenarios, you should test them.
> Any input is highly appreciated.
> Carly
>
HTH
John
没有评论:
发表评论