Backup Scenario

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Backup Scenario

Backup Scenario

Rate Topic

Display Mode

Topic Options

Author

Message

y.koteswarrao-652921

Posted Tuesday, October 13, 2009 6:31 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

Hi,

Backup Scenario

sunday 5 pm - full backup
Daily 7 pm - differital backup
Every 15 min - Transacional backup

Thrusday at 8:25 pm system was crash, what is approach in bringing the database back.

Can any give solution to above scenario?

Thank you
Koti

Post #802101

Animal Magic

Posted Tuesday, October 13, 2009 7:23 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:08 AM
Points: 983, Visits: 13,350

y.koteswarrao-652921 (10/13/2009)

backup tail log
restore sunday backup
restore thursdays diff backup
restore tlogs for 7.15,7.30,7.45,8,8.15
restore tail log backup

is this an interview question? do i get the job?

Post #802129

y.koteswarrao-652921

Posted Wednesday, October 14, 2009 5:05 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

Hi,

Thank you every much i have give same reply , but i missed the tale backup.

Thanks
Koteswar Rao.

Post #802636

y.koteswarrao-652921

Posted Friday, October 16, 2009 6:36 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

Hi,

As you said to take the tale backup of transaction log,my doubt is how to take the tale back up if the system crashes!

Could you please reply

Koteswar rAo

Post #804119

MANU-J.

Posted Friday, October 16, 2009 3:03 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:56 PM
Points: 1,658, Visits: 8,564

If your db crashes for whatever reason, you have to backup your transaction log so that you can do point in time recovery. This last backup is called Tail log backup. If your data file (MDF) is unavailable you need to use WITH NO_TRUNCATE option:

-- Back up the AdventureWorks tail-log
BACKUP LOG AdventureWorks
TO DISK = N'c:\AdventureWorksTailLog.bak' WITH NO_TRUNCATE

If your database is in OFFLINE or EMERGENCY state then tail log backup isn't possible.

http://www.sqlteam.com/article/introduction-to-sql-server-database-backups

MJ

Post #804575

satheessh

Posted Wednesday, December 28, 2011 5:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 7:24 AM
Points: 4, Visits: 53

first we restore fullback up
after latest differential backup
after that 7 to 8.15 transactional backup (5 sets)

after tat we should take tail log back up of particular database by putting db in single user mode which is in restoring state

Post #1227293

GilaMonster

Posted Wednesday, December 28, 2011 7:07 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

satheessh (12/28/2011)

after tat we should take tail log back up of particular database by putting db in single user mode which is in restoring state

No. Tail log backup has to be done before the restores start (otherwise there's nothing to back up)

Please in future post new questions in a new thread.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1227334

Dev

Posted Wednesday, December 28, 2011 7:09 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:05 PM
Points: 2,013, Visits: 1,566

satheessh (12/28/2011)

Two points to mention here...
1) Its OLD thread. (Posted Tuesday, October 13, 2009 7:01 PM)
2) Tail Backup should be first step.

~Dev~

Post #1227335

« Prev Topic | Next Topic »

Permissions