Log shipping and Manual backups

18 Jan 2006 8:19 PM

Parks

I have set up a log shipping on my master and backup database, where a full
backup of the master database is done each day at midnight and restored to
the backup database. The master databases transaction logs are then backed
up and restored to the backup database every 10 minutes.

My users want to also have the ability to do manual full database backups as
well. However I am unsure whether or not this will have the affect that the
log shipping operations.

Will this cause the master and backup databases to get out of synch until
the full backup and restore is performed at midnight?

Thanks in advance

18 Jan 2006 8:51 PM

Tibor Karaszi

No worries. Database backup does not break the log backup chain.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quoteHide quote

"Parks" <treatyourself***@hotmail.com> wrote in message
news:%23OJ4KyGHGHA.3120@TK2MSFTNGP10.phx.gbl...
>I have set up a log shipping on my master and backup database, where a full backup of the master
>database is done each day at midnight and restored to the backup database. The master databases
>transaction logs are then backed up and restored to the backup database every 10 minutes.
>
> My users want to also have the ability to do manual full database backups as well. However I am
> unsure whether or not this will have the affect that the log shipping operations.
>
> Will this cause the master and backup databases to get out of synch until the full backup and
> restore is performed at midnight?
>
> Thanks in advance
>