HI all,

I just have this one question in the backup command if the password should be the same as used in the master key creation or can it be...

Okay, I'll do that. It will work after I bounce the services. But, the next night scheduled backup fails for one or more databases with these messages and the session...

No, we only have one type of backup -full backup every night

It is a seperate process for backup to disk at 9pm then around 12am the tape backup is scheduled..

The...

David,

The backup is done to the local disk on the server and then to the tape.

I tried taking backup manually, but I get an error that Backup...

Thanks for your reply. There are no databases in suspect mode..

In the log file viewer, I see 'The operating system returned error 1450(Insufficient system resources exist to complete the...

Looks like its not done yet. After I restarted the services 2 days back, I was able to bounce the database and the sessions got killed.

But, today I...

I did net stop mssqlserver and net start mssqlserver.

The backup works fine now.

Thanks for all your help.

David,

I checked the space for the backup folder, it looks fine has a lot of free space. And, I tried to backup the database manually from SSMS, I got...

I just looked at SQL server error log on the SSMS, I see this message for this SPID:

The operating system returned error 1450(insufficient system resources exist to complete the...

David,

I tried to open the Log file from SSMS, I get this message

THe file can not be opened because it is being used by another process. Please close...

Okay, if this is the only option then I should probably let everyone know that the databases will go down and bounce the SQL server service.

After the restart, if the...

No.. I just tried to bounce the database. There are 7 other databases that are being used on the same server, so I wont be able to restart the service...

I stopped all the software services and tried to bring the db offline. I get this message, Alter Database failed because a lock could not be placed on database 'wbs2007pg'...

I only 2 processes open for this database with same Process ID. The status for both are suspended and the command is KILLED/ROLLBACK. Application is SQLAgent-TSQL JobStep (Job .... :Step...

But, the process is in suspended state since yesterday and I just ran the command again and the estimated rollback completion is still 13%. Is there a way to...