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.
| Author |
Topic |
|
Richard101
Starting Member
30 Posts |
 Posted - 2008-09-11 : 11:33:52
|
| Hi y'allStange one - I was called to a failing backup of a SQL2k enterprise. The maint-plan was set to 'all databases', but I changed that, and narrowed it down to one database that would cause backups to always hang (IE: no error message).Manual backups of this database work fine - but not scheduled ones. Checking the owner - there wasn't one !! so I used sp_changedbowner to set the owner to the same as the others (IE: the windows account used to start the two sql services).I've compared the database properties with another one on the same box, and I've compared the properties of the backup destination folder, and everything looks the same.Also, I've checked the account running sql-services and its correct (and it works for all other database backups).Lastly I made a fresh maint plan (and set-up an output-log) for just this one db, and running as the sa user - still the same.huh?cannot think of anything else to do :-(richard101 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
failing backup