August 12, 2002 at 4:51 pm
My application returns the following error when it attempts to connect to the SQL Server during a transaction log backup...
Cannot open database requested in login 'login_name'. Login fails.
Have you been able to work around this problem before? Any help appreciated.
August 12, 2002 at 5:12 pm
Check to see if the default db associated with the login is missing.
Andy
August 15, 2002 at 7:02 pm
Thanks Andy... problem still exists, default db for login is set to the correct db.
August 15, 2002 at 7:59 pm
How long is the backup taking? Box heavily loaded? No chance its a bug in your code (just asking!)? Db should not block connections because of a log backup, have seen cases where connection would timeout because of CPU/disk load related to ongoing backup. Messages from error log?
Andy
August 20, 2002 at 4:51 pm
After reading your reply and doing some old fashioned 'machine watching' I have found what appears to be the problem. The job to run the transaction log backup was created with the SQL Maintenance Plan Wizard and the option to repair minor errors was selected. This caused the command DBCC CHECKDB(db_name, REPAIR_FAST) to be called. This statement requires the database to be in single user mode to run. I changed this job yesterday and have successfully had the transaction log back-up run 4 times since with no problems. Cheers Andy!
August 21, 2002 at 6:21 am
Thanks for the follow up!
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply