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 |
|
Tracey
Starting Member
40 Posts |
 Posted - 2004-06-17 : 03:40:48
|
| Need Help!Database Maintenance Plan(Actions Performed:Optimizations,Integrity Checks,Database Backup,Log Backup)Fails.But it backed up the database successfully,integrity and optimization has been sucessful and I have looked the DB Maintplan History it says:Activity : Delete Old DB Backup FilesStatus: FailedError Number: 0Message: 1 Files DeletedI cant figure what cause the error.Everything seems to be fine.Did anyone experienced these problem?any help/advice would be much appreciatedTracey |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-17 : 12:22:43
|
| This is exactly why database maintenance plans should be avoided. The error information just doesn't give enough information to debug. You might find more information in the SQL Server Error Log. Check the log and post the error info here.Tara |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-17 : 13:35:04
|
quote:
Originally posted by tduggan
This is exactly why database maintenance plans should be avoided.
Its a cracker isn't it?Error Number:0 - So no errorMessage: 1 Files Deleted So it worked then?Status: Failed Is that a maybe or a for definite? Kristen |
|
|
|
Tracey
Starting Member
40 Posts |
Posted - 2004-06-17 : 20:12:22
|
| Hi Tara,thanks for your reply. I am new to this organization.I looked in the error log(should have done that before :( )It seems there are 2 files .MDF and .LDF in that folder(dunno how it was there, here everyone have access to the server)iam investigating on that now. Thank you so much. TraceyMicrosoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'xxx' as 'Data_DOMAIN\Administrator' (trusted)Starting maintenance plan 'XXXDaily' on 17/06/2004 11:00:01 PM[1] Database XXX: Database Backup... Destination: [e:\XX.BAK] ** Execution Time: 0 hrs, 1 mins, 58 secs **[2] Database Horizon: Verifying Backup... ** Execution Time: 0 hrs, 0 mins, 53 secs **[3] Database Horizon: Delete Old Backup Files... Unable to delete file e:\xxn_db_200406092300.LDF. Unable to delete file e:\xxn_db_200406092300.MDF. 1 file(s) deleted.Deleting old text reports... 0 file(s) deleted.End of maintenance plan 'HorizonDaily' on 17/06/2004 11:02:52 PMSQLMAINT.EXE Process Exit Code: 1 (Failed) |
|
|
|
Tracey
Starting Member
40 Posts |
Posted - 2004-06-17 : 20:36:40
|
| Well it seems someone have restored the database and assigned to datafile and logfile to that directory :( |
|
|
|
Tracey
Starting Member
40 Posts |
Posted - 2004-06-17 : 22:27:30
|
| the problem has been fixed.Thank you everyone.Tracey |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-17 : 22:49:10
|
quote:
Originally posted by Tracey
Well it seems someone have restored the database and assigned to datafile and logfile to that directory :(
I'm having a bit of a struggle understanding why SQL thought those files were candidates for deletion. Normally the maintenance plan logs backup files, with a retension date, and then deletes them when they expire, but I don't see how an MDF/LDF pair would get into the "list of backups".I'm probably worrying about nothing, but you might want to keep an eye on it, or have a look at the list of backup files that SQL is logging.Kristen |
|
|
|
Tracey
Starting Member
40 Posts |
Posted - 2004-06-17 : 22:54:42
|
| Kristen,I tought the same thing. But those MDF and LDF files are TestDatabase files. So I detached and attached the database with new location.Hope it will fix the problem, but will keep an eye on it.ThanksTracey |
|
|
|
|
|
|
|
|
Database Maintenance Plan Fails