RE: SQL server restore

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 12:46:21 GMT

Hi llya,

Thank you for your update. It seems that the problem is complicated and
need some time to troubleshoot it.

As for the error message like the one you encountered, from my experience,
it is a general one and may factors might cause it. The information is
somewhat not so accurate that in some cases, even all operation is executed
locally. From the information provided, there is possiblly a database
damage and we should trouble shoot it step by step to narrow down it. Hope
you could understand it.

As for the SQL Server 2000 work on the Server A, since you could not do
restore the backups on it. I think you should run DBCC CHECKDB one all the
database espacially on the databaser 'dtpath' database. So that we could
make sure that the backups from Server A is good. It is better to restored
the backup of 'dtpath' to another SQL Server (just create a new one and
restore from the backup). If no SQL Server is available, create a new
database with another name and restore it from the backup is an approach.

Looking forward to your reply. Thanks.

Best wishes

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restore database
    ... Initialize the backup device with INIT. ... My database is very small. ... Microsoft SQL Server Management Studio Express ... Restore failed for Server 'HOMEDEV\SQLEXPRESS'. ...
    (microsoft.public.sqlserver.setup)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: restore permissions to a login
    ... restore the database. ... what about SQL Server installations that use ... > I have run into a situation that a 3rd party backup and restore solution ... > database roles and database_creators server role. ...
    (microsoft.public.sqlserver.server)