Re: sqlbackup
From: Kimberly L. Tripp (Kimberly@nospam.sqlskills.com)
Date: 01/31/03
- Next message: Anthony: "Re: .NET and MSDE"
- Previous message: Richard Waymire [MSFT]: "Re: .NET and MSDE"
- In reply to: jeff: "sqlbackup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Kimberly L. Tripp" <Kimberly@nospam.sqlskills.com> Date: Thu, 30 Jan 2003 15:55:22 -0800
Hi Jeff - A few questions to determine the state of your database...
0) Most important - what file(s) are damaged? See the error log for this
information.
1) Do you have ONLY full database backups (from 2 weeks ago)?
2) Did you have any database options set (specifically do you remember if
you had trunc. log on checkpoint' set).
3) How were you managing your log if you weren't doing log backups? Maybe
it's just grown quite large?
4) Something you can try... It probably WON'T work but it's an option and
I've seen it happen a few times on 7.0. If you're lucky you may have hit
it... are any files or harddrives specifically damaged? If there are no real
signs of hardware failure then you can try this option:
You could allow updates to the system tables
Reset the database status to turn off the suspect flag
Restart SQL Server
There are cases where the database is not really suspect. Here are the
procedures for SQL Server 2000 and I believe that they are the same for SQL
Server 7.0. Ugh - I wish I remembered more about 7.0 but a brief look at
these procedures and they seem the same
http://msdn.microsoft.com/library/en-us/trblsql/tr_servdatabse_494j.asp?fram
e=true
Also, check out the KB for anything more specific to your sp level, etc.
And keep us posted. There's WAY more that we can still do even if it still
shows as suspect after this change.
1) You can backup the tail of the log (if you have a recent backup and have
NOT cleared the log in any way). The backup is BACKUP LOG dbname TO device
WITH NO_TRUNCATE.
2) You can restore that backup and restore the tail of the log...
3) You'll have up-to-the-minute recovery.
Again, keep us posted.
Thanks,
kt
**** Please reply only on the newsgroups! Include dml/ddl, when possible.
Thanks ****
Kimberly L. Tripp
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com
President, SYSolutions, Inc. www.SQLSkills.com
"jeff" <jarmington@attbi.com> wrote in message
news:094b01c2c8b1$c12fff30$8af82ecf@TK2MSFTNGXA03...
> Hello, I am really hoping somebody can help me. I am
> running into an error I have never seen before. I have a
> client using SQL 7.0. I usually backup the database
> through a maintenence plan to the hard drive and then the
> tape picks up the backup. I stopped in there to day to
> check it and I found it has not backed up in 2 weeks. I
> tried to back it up manually but I could not. I am
> getting an error that the database has been marked
> suspect!!
>
> What can I do about this I need this dtabase backed up it
> is crucial. Somebody please help!
>
>
> Thanks,
> Jeff
- Next message: Anthony: "Re: .NET and MSDE"
- Previous message: Richard Waymire [MSFT]: "Re: .NET and MSDE"
- In reply to: jeff: "sqlbackup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
