Re: Problem with database restore after MS03-031
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 02/24/04
- Next message: MSD: "MS SQL security best practices?"
- Previous message: Erland Sommarskog: "Re: SQL with Sybase"
- In reply to: Terry Harris: "Re: Problem with database restore after MS03-031"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 10:20:04 +1100
Hi Terry.
If the AV is coming from the client tools, you might do well to re-install
them (& SPs), or perhaps attempt from another PC. If these fail, another
option is to try to restore from t-sql commands.
If the AV is coming from the server, there may be two further options - (1)
the backup could be corrupt or (2) you've encountered a bug in SQL Server
itself. If the backup is corrupt (not uncommon) you might attempt to dbcc
checkdb the database, fix whatever problems exist then re-initiate the
backup process. If you've encountered (2), then you very likely have a case
for PSS.
Given the above, I'd be first attempting a t-sql restore command to identify
if it's a server bug, because if it is, the best option is probably a PSS
call.
Regards,
Greg Linwood
SQL Server MVP
"Terry Harris" <Terry_member@newsguy.com> wrote in message
news:c1gjhp0ub2@drn.newsguy.com...
> Just using the Enterprise Manager to perform and restore the backups.
>
> In article <O$VtpNy#DHA.2524@tk2msftngp13.phx.gbl>, Greg Linwood says...
> >
> >Hi Terry.
> >
> >If the AV's coming from the SQL Server process, then this is probably a
PSS
> >case, but could you fill us in on how you're performing your backups? Are
> >you using SQL commands, SQL Enterprise Manager or a 3rd party product
such
> >as BackupExec, LiteSpeed etc?
> >
> >Regards,
> >Greg Linwood
> >SQL Server MVP
> >
> >"Terry Harris" <Terry_member@newsguy.com> wrote in message
> >news:c1g7qa02pjm@drn.newsguy.com...
> >> MS03-031 was installed on one of the servers here. Since then any
attempt
> >to
> >> restore a database results in an Access Violation. If MS03-031 is
removed
> >then
> >> restores work correctly. If MS03-031 is reapplied then the AVs come
back.
> >> Other servers here with MS03-031 do not have this problem.
> >>
> >> Anyone else seen this or know what might cause it?
> >>
> >
> >
>
- Next message: MSD: "MS SQL security best practices?"
- Previous message: Erland Sommarskog: "Re: SQL with Sybase"
- In reply to: Terry Harris: "Re: Problem with database restore after MS03-031"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
