Hi All,

Good Morning.

I Have installed SMS 2003 on one of my Servers with SQL Server 2000 as its
database with SP4.Some days back my server started misbehaving for which i
did a fast repair for the Operationg System which is windows 2003.After which
my SQL Server 2000 stopped working.Now Whenever i try to start my SQL Server
service it pops up with these three error message in my Event Viewer.The
Error Messages are :
1.18052 :Error: 3456, Severity: 21, State: 1.
2.18052 :Error: 3313, Severity: 21, State: 2.
3.18052 :Error: 2775, Severity: 16, State: 1.

Kindly help me get my SQL Server Started as it is a production server and
dont want to end up reinstalling everything again.

Thanks,
Raman

Raman,

I don't think that I can help you with this, but I would like to point you
to some KBs that may give you a clue:

Error 3456 - A transaction log problem, often associated with log shipping.
Are you doing log shipping?
http://support.microsoft.com/kb/831950 - log shipping issue
http://support.microsoft.com/kb/295644 - minimally logged transaction file
problem, but should have been fixed years ago.

Error 3313 - Another transaction log problem, database does not recover or
is marked suspect.
http://support.microsoft.com/kb/891585

Error 2775 is "Code page %d is not supported by the operating system."  If
you check old logs, were you already getting this before you problems
started?  If it started with your quick repair, try to find out what
changed.  See:
http://msdn2.microsoft.com/en-us/library/aa214328(SQL.80).aspx

If you provide more information, such as the text associated with the errors
it is more likely that someone will recognize your problem.  The error
numbers alone are not enough information.

RLF


Show quoteHide quote

Live server running out of space - Can't reduce Transaction Log!
database and tlog backups - MSSQL 2000 & MSSQL 2005
Copy views from one database server to another
Optimizing and shrinking large highly-transactional database
Update Timeout and indexes