Help on Backup&Recovery and suspend mode

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Help on Backup&Recovery and suspend mode

Author

Topic

saivyshnav
Starting Member

17 Posts

Posted - 2007-01-29 : 12:31:57

Hi all(I’m New help me)

My senior DBA went on vacation, he hand over SQL trail server to me

That Trail server having scheduled Full backup every Monday evening
Tue day onwards it will take Diff Backup and every day it will take Transactional back hourly based

Every Mon day: full backup
Tue to Sun day: diff Backup
Every day each hour: Transactional Backup

some one tell me if my system crashes on ThursDay day at 12 PM
how to restore my data
Take it above as a scenario

saivyshnav
Junior DBA

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-01-29 : 12:40:09

oh. this sounds like a test question. Are you taking a class?

-ec

saivyshnav
Starting Member

17 Posts

Posted - 2007-01-29 : 12:47:08

Hi Eyechat

To Day my DB manager Hand over DB server(Trail server),If any case system crashes(I hope that may not happend god grace) I have Recovery DB immediatly ,for you guy's it is very simple but for us practical tough,so that I asking this scenarios

thanks in Advance

Regard

saivyshnav
Junior DBA

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-29 : 13:55:38

This sounds like something you should have asked the Senior DBA before he went on vacation.

Since you don't have an actual emergency to deal with, you should start by reading the "Backing Up and Restoring Databases" section in SQL Server Books Online. It gives a much better and more complete explanation than anything we could write here.

CODO ERGO SUM

nr
SQLTeam MVY

12543 Posts

Posted - 2007-01-29 : 19:20:42

>> My senior DBA went on vacation, he hand over SQL trail server to me
Really?
Doesn't sound like he did.
I would ask your IT manager or whoever fills that role what they expect of you and maybe suggest they get in a temp very quickly if this is important.
Otherwise say that if there is a problem it will have to wait until the senior dba gets back.
Is he the senior dba or the only dba?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-01-29 : 19:37:10

did he go on vacation or did he quit?

-ec

Kristen
Test

22859 Posts

Posted - 2007-01-30 : 01:23:34

"some one tell me if my system crashes on ThursDay day at 12 PM
how to restore my data"

Depends on the crash, and whether the Log backups are on a different spindle to the MDF files.

For example, assuming the Log backups are on a different spindle and the database is corrupted rather than "the whole server caught fire"

you can make a final TLog backup and thus recover the whole database without loss - your normal database integrity test routine (I presume you DO have a procedure written up for testing database integrity, and that you are doing that in addition to taking the backups?) will then tell you whether the restore was good, or not.

If that's NOT the case then you need to have words with the DBA:

1) Hourly is too infrequent. If you are bothering to take the Tlog backups at all why waste an hours data entry time? 10 minutes is a good compromise between system load an recovery time. Mind you, if your system is 24x7 critical you should fail-over redundancy anyway. I digress.

2) You are probably going to have to recover to the last TLog backup before 12PM Thursday. Mind you, that depends on where the backups are located. Your DBA should have a written Standard operating Procedure for the location of the files, and the procedure in the event of disaster recovery. If the backup files are on the server, and the server did actually just catch fire (or some other catastrophic failure) then you have NO recovery route to 12PM THursday!!!

Given that your DBA is "on holiday" best you also check what the state of your database maintenance plans is ...

Kristen

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2007-01-31 : 04:41:46

Hi

Latest fullbackup
All Diffbackup from latest fullbackup
Last tlog backup

SreenivasaRao
Bangalore,INDIA

Kristen
Test

22859 Posts

Posted - 2007-01-31 : 05:24:37

"Latest fullbackup
All Diffbackup from latest fullbackup
Last tlog backupp"

Errrm .... No! that won't do it.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources