Our SQL Server 2000 crashed a while a go and i am wondering if this
could cause
data to be corrupted ?
Could someone tell me what the procedure of SQL Server 2000 is after
and or during a server crash ?
Dennis VeldersDennis
If you do an access to the database , just run BACKUP LOG WITH NOTRUNCATE
option
Then RESTORE the last FULL database and apply all LOGs with NORECOVERY
option except the last one that you did just after the crash but this time
WITH RECOVERY option
For more details please refer to the BOL
"Dennis Velders" <d.velders@.catalpa.nl> wrote in message
news:1141288312.167931.162580@.z34g2000cwc.googlegroups.com...
> Our SQL Server 2000 crashed a while a go and i am wondering if this
> could cause
> data to be corrupted ?
> Could someone tell me what the procedure of SQL Server 2000 is after
> and or during a server crash ?
>
> Dennis Velders
>|||Hi
This will depend on what damage has been caused by a crash. SQL Server will
roll back any outstanding transactions when it starts, therefore you database
should be consistent if it comes back online.
If your database does not come online it will depend on what is
corrupted/missing as to what you can recover. The worst case being that you
will have to resort to a backup.
Have you run a DBCC CHECKDB on the database?
John
"Dennis Velders" wrote:
> Our SQL Server 2000 crashed a while a go and i am wondering if this
> could cause
> data to be corrupted ?
> Could someone tell me what the procedure of SQL Server 2000 is after
> and or during a server crash ?
>
> Dennis Velders
>|||Yes, i did all the checks.
But after a normal shutdown a while ago the data was fine.
So, i have two options for the maybe corrupted data:
1. The Query mechanism of SQL Server is wrong after the crash
2. The Views display the wrong data, vew design problem
Someone is blaming the server for the corruption...
I want to be sure.|||Hi
If you run checkdb and it indicates not errors, then you may also want to
reindex and update the statistics. If it continues to give different results,
then try running the query in Query analyser and verify that the results are
matching the query and the underlying data.
John
"Dennis Velders" wrote:
> Yes, i did all the checks.
> But after a normal shutdown a while ago the data was fine.
> So, i have two options for the maybe corrupted data:
> 1. The Query mechanism of SQL Server is wrong after the crash
> 2. The Views display the wrong data, vew design problem
> Someone is blaming the server for the corruption...
> I want to be sure.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment