Backup problem - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Backup problem

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:05:35

Dear Gurus,

I have asked the same problem in two weeks ago. Please dont avoid this post as a duplicate post

still I have the same problem.

I took firstly Full backup and then transaction backup in 20 minutes interval sheduled first time everything goes okay! It's succesfull but, at the next execution time it shows the db in restoring
mode and then i run restore database with recovery statement

what i have to do? Please suggest me to solve this problem.

it just screwed me

Thanks
Krishna

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-14 : 14:11:52

Are you performing a restore at the time the database goes into restoring mode?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:14:24

No!! I didn't do that. No one knows about SQL backup and restore!!
I am the only persion to handle the backup and restore..

When i am getting error that time only i am restoring the database

Thanks
krishna

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-14 : 14:18:58

I doubt that the backup plan is causing this. But to be sure, please post your code.

Also you may need to run SQL Profiler to determine exactly what is going on.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:20:45

Tara Kizer, Thanks for the quick response.

It is a maintainance plan. I didn't write any code. Shall I post the maintanance plan code..?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-14 : 14:24:36

No. I seriously doubt that a maintenance plan would cause this.

You need to check Event Viewer in the Application and System Logs to see if there are any errors that occurred at the same time it went into this state.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:31:39

I have checked event viewer (Application,Security and system) , at the same time i didnt find any information from the three sections. It was happent by yesterday 8.00 PM (CST). The same time i didnt find any single entry in those sections. I got one entry by yesterday 6:12 PM. which is
"SQLServerAgent service successfully started.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
Because of I have restartd the SQl server. I dont know what i have to do.

Thanks
Krishna

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-14 : 14:45:00

You should open a case with MS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:48:48

Oh My god! I am going to take full backup and drop all plans,
then will do from the begining, let me see what will happen

Thanks For your quick responses Tara. I am not a guru like you to open case with MS :(

Thanks
Krishna

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-14 : 14:51:14

You can even be a beginner to open a case with MS. It does not require any special knowledge (except a little information about your environment) as they'll be analyzing your environment to figure out what happened.

Oh and I'm not a guru.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-11-14 : 14:55:42

I am appreciate your politeness tara, I have seen all of your posts and I have steeled lots of your code with out your permisson from sqlteam.com.

he he he he

Thanks
Krishna

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-11-14 : 15:23:37

So you done full backup then the transactions logs fire every 20 minutes.
So you now trying to restore...using gui i thought if im not mistaken it tells you to do a tail end backup or something of that nature.

The backups should display in the gui and must be carried out like so
Full backup
TRANSACTION LOG 1
LOG 2 etc

What is the exact problem

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-14 : 23:09:32

Did you check sql server log for restore message?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources