Backup and Restore

Question

SQL Server 2008 R2

Hi guys, I am new in replication and learning/testing <Back and Restore> procedures.

I am following the TechNet article:

Strategies for Backing Up and Restoring Snapshot and Transactional Replication

http://technet.microsoft.com/en-us/library/ms152560.aspx 

I have doubt over restoring the Subscription database:

In the Technet article is written:

<

Is the latest subscription database backup more recent than the maximum distribution retention setting on the distribution database? (This determines whether the Distributor still has all the commands that are required to bring the Subscriber up-to-date.) If yes, go to step 2. If no, reinitialize the subscription. Recovery is completed.

>

Form my side I need more clarification about:

Is the latest subscription database backup more recent .....

My question is:

How can I calculate the last backup time (It is not clear how can I calculate the time for the last backup) to be compared with the distribution retention time?

Many thanks for you help

Answer 1

Right click on the database using SQL Server Management Studio. Select Properties, the last backup date should be the first field in the dialog.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

You can get the details of the backup using the following query.

 

SELECT BACKUP_START_DATE,BACKUP_FINISH_DATE FROM MSDB.DBO.BACKUPSET WHERE DATABASE_NAME='Yourdatabase'

---

Thanks
Manish

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.