RE: SQL server restore

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Date: Fri, 19 Mar 2004 08:47:19 GMT

Hi llya,

Thank you for your update. So, you could not even restored the backup from
the backup from Server A? Could it be restored on Server A? Before you try
this, please take another approach as follows:

1) When you create a new database, you just run

exec sp_configure 'allow updates', 1
reconfigure with override
go
update sysdatabases set status =0 where name = 'dtpath'
go
exec sp_configure 'allow updates', 0
reconfigure with override

restore database pubs from disk='<The backup file path>' with recovery
-- note that the 'with recovery' option should be added
go

How about it ?

2) If it does not work in Server A, without any other application using the
databaser 'dtpath' ( you could use sp_who to monitor if any process is
using the database 'dtpath'), right click the 'dtpath' and select 'all
tasks', choose 'detach database'. then copy the dtpath.mdf to the Server B,
in the Enterprise Manager of the Server B, delete the database 'dtpath' (
or run 'drop database dtpath' in Query Analyzer) and run DBCC CHECKDB on
all other databases, then right click the 'Databases' and choose 'All
tasks' and choose 'Attach database', then choose the 'dtpath.mdf copied
from the Server A. you may have some warnings that the dtpath.ldf is not
correct but press 'OK' and the system will create a new log file for it.
Could these method restored a database on the Server B?

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

  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)