July 24, 2003 at 6:43 pm
I've installed SQL 2000 on an brand new W2K server, patched up to w2k sp3.
In the SQL Enterprise Manager, I create a Maintenance Plan, and go with the defaults. I choose to backup all the databases, and back up transaction logs.
I go over to SQL Server Agent, and run the events directly. Backup works fine. Transaction log backup always fails step 1.
An analysys of Maintenance Plan History shows that the Model db trans log backed up fine, but the others died.
I've installed SQL SP 3, I've even uninstalled and reinstalled the SQL server itself.
A browse of the TechNet turned up nothing.
ANybody seen this behavior before, or have a suggestion? Im' stumped.
July 24, 2003 at 11:20 pm
The other DBs are probably not in Full Recovery Mode, therefore tlog backups cannot be done.
Suggest you only have tlog backups for your user databases, not for the system databases.
Did you set your maint plan to generate a report? If so, track down the latest one. It should contain more meaningful messages, hopefully confirming what I've said above.
Cheers,
- Mark
July 25, 2003 at 11:04 am
Easiest way to check mccork's suggestion...
In EM, drill down the databases. Right click on each database and select properties. Go to OPTIONS. What is Recovery Mode set for? If it's not set for FULL you can't do transaction log backups.
-SQLBill
July 25, 2003 at 11:32 am
That was it, folks. Thank you all for your help!
This is the first time I've installed SQL 2K cold; the other time was doing an upgrade to SQL 7, and I believe the upgrade-install took on the attributes of the 7 server; as one would expect.
Againk, thanks!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply