So what we have to do to get rid of this error? plz advice me

Thank You All..

I have created a mantenance plan instead of the backup script. Now the msdb is backing up...

It is not a mapped drive!

msdb is there in system databases and Iam able to take the backup of it.

backup database msdb to disk='Z:\Backups\msdb.bak'

I changed the code master.dbo.sysdatabases to sys.databases.

But still have the same problem.msdb is backing up when I ran the job manually,but not when I scheduled it to run midnight.

Iam using the same procdure to backup system databases in all instances.In one instance the msdb is not backing up when the job runs at midnight. If run the job...

Hi,

I have checked the baclupset table and it showing as only the master and model were backed up,no history of msdb.The other instances msdb is backed up but in this...

Thank you..I got it

the problem here is it is a clustered environment.

the instance has group1 in cluster administrator contains 3 drives(D,E, F)

Now we created a group2,which contains only one drive Z to keep...

Hi,

Iam running the above stored procedure as job from sqlagent. The job history shows the job was success and has no errors, eventhough the msdb database not backedup!

why its showing...

thank you..

Iam currently taking log backups for user databases only. How frequently do we need to schedule log backups for modl,msdb?

we can not take log backup for master database right?

Thank You..

I understand like this....

So, if log backups run every 1hr and database crashed at 10:59am. That means whatever the activity happened between 10:00am to 10:59am will exist in ldf...

Thank you veru much Gail..

You clarified me many things..I have still some questions..

As you said that The log records contained in the backup will be replayed against the database.Here I...

thanks Steve..

Yeah Samule,

How to manually change the sample password to something complex in the instmsdb.sql..

I did not understand where to find instmsdb.sql..?and do we need change this before installation.? could...