sql server database maintenence plan

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)

sql server database maintenence plan

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-21 : 08:08:46

syed writes "I have setup backup plan of master, module and msdb databases.
When I checked sql server log I found these messages
1)spid54 Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
2)spid54 Starting up database 'model4IDR'.
3)Recovery is checkpointing database 'model4IDR'.

Why this happen and Can I run this command which I found in Microsoft site article id :272683

RESTORE DATABASE model WITH RECOVERY.
"

jason
Posting Yak Master

164 Posts

Posted - 2005-04-21 : 12:38:08

syed,

Are you having an issue with backing up the databases or restoring the databases?

saahmed
Starting Member

1 Post

Posted - 2005-04-21 : 13:23:48

Thanks for taking intrest for this issue. I don't have any problem to backup or recovery.Just for test I made back up of model database and restore as model2 database, they work fine.
Following are the message in sql server logs
1)spid54 Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
2)spid54 Starting up database 'model4IDR'.
3)Recovery is checkpointing database 'model4IDR'

spid54 Database backed up: Database:master, creation date(time): 2005/08...
Bypassing recovery for database:'master4IDR' because it is marked IN LOAD.
spid54 Starting up database 'master4IDR'
spid54 Recovery is checkpointing datbase 'master4IDR'

Just I got these above messages in sql server logs even database names and mdf and ldf files have there original names.

Best Regards

Syed a Ahmed

jason
Posting Yak Master

164 Posts

Posted - 2005-04-21 : 13:39:42

I may be off here, but I think this will help you

http://support.microsoft.com/?kbid=822852

delpiero
Yak Posting Veteran

98 Posts

Posted - 2005-06-14 : 22:45:59

I have found the same messages in my SQL Server logs. I found that the model4IDR thing is the database created by Veritas BackExec which has the Interlligent Disaster Recovery option. The Veritas backup process will use these databases during backup. You can check whether your system admin colleagues are setting up a Veritas backup job which backups all SQL Server databases through the SQl Server agent.

Regards,
delpiero

kromm
Starting Member

1 Post

Posted - 2007-05-30 : 11:59:07

Spam deleted by tkizer.

Rustemacl
Starting Member

2 Posts

Posted - 2008-09-25 : 13:05:42

SPAM deleted by tkizer.

Rustemacl
Starting Member

2 Posts

Posted - 2008-12-12 : 21:27:30

[URL=http://xcheap.info/info-Adobe_InDesign_CS.html]Adobe InDesign CS[/URL]

[url=http://xcheap.info/info-Adobe_Premiere_PRO_2.0.htmlcheap adobe primiere[/url]
[url=http://oemstore.biz]oem software[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources