Viewing 15 posts - 451 through 465 (of 748 total)
Error 9904: An error occured while processing the log for database 'CheckListDB'.
This happened when I tried to attach it directly to the SQL 2000 server
July 20, 2011 at 8:55 am
GilaMonster (7/20/2011)
halifaxdal (7/20/2011)
So, I tried to upgrade the database first, I downloaded the upgrade advisor from Microsoft but again another error pops up:
That's not how you upgrade a DB. Upgrade...
July 20, 2011 at 8:33 am
I tried to follow the post: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
I encountered this error when I do:
DBCC CHECKDB(CheckListDB_Data, REPAIR_ALLOW_DATA_LOSS)
Msg 946, Level 14, State 1, Line 1
Cannot open database 'CheckListDB_Data' version 539. Upgrade the database...
July 20, 2011 at 8:03 am
GSquared (7/19/2011)
Have you tried the create database options that rebuild the log file?Create Database For Attach_Rebuild_Log
(Check MSDN or BOL for the full syntax.)
Can you elaborate? Can you provide your...
July 19, 2011 at 2:58 pm
Sorry I have to go, I am being pulled out to another case, I haven't finished reading the "http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/"
I will read it once I am back, but can you simply...
July 19, 2011 at 2:57 pm
GilaMonster (7/19/2011)
Try this
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
If it fails, tell us exactly at...
July 19, 2011 at 2:53 pm
Steve Jones - SSC Editor (7/19/2011)
If...
July 19, 2011 at 2:45 pm
The new server is SQL 2005, the damaged files are from 2000
July 19, 2011 at 2:44 pm
Ninja's_RGR'us (7/6/2011)
steveb. (7/6/2011)
the maintainence plan wizard will also setup these date stamped backups for you.
MP have always been buggy over the years... I've pretty much lost all confidence in...
July 6, 2011 at 2:54 pm
Thank you my friend, I will check later.
July 6, 2011 at 5:46 am
Ninja's_RGR'us (7/5/2011)
I preffer 4 files. Like DBName - PROD - 2011-07-05 07H00.bak.That way you know exactly what's in the file.
Exactly! But how do I do this in SSMS? and...
July 6, 2011 at 5:22 am
Ninja is right
So can I create one file including 4 weekly backups? or can I create 4 files with different name?
July 5, 2011 at 1:42 pm
Even if this applies, it should be the other side server, that server is a SQL 2000, does it have this function? I don't know.
Anyway, it suddenly works, no any...
June 6, 2011 at 4:22 pm
Thanks for your reply.
The account is a SQL account, I guess this lock out scenario doesn't apply, right?
June 6, 2011 at 1:17 pm
What I just figured out a work around is: (and it is working)
Configure the job running under a dedicated proxy with a credential created from the dedicated account (not the...
June 3, 2011 at 12:24 pm
Viewing 15 posts - 451 through 465 (of 748 total)