RE: Installation Question (Cross-Post)

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

From: Rob Beene [MSFT] (rbeene_at_online.microsoft.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 15:13:36 GMT

Hey Tim,

Thank you for your post regarding how to restore database on MSDE. Below
are the answers to your questions:

1. My question is, what a backup is restored from a different server than
is was created (both servers will be the same version of SQL) should I
anticipate any problems using this method?

>>>>>As long as the file locations are the same meaning that if on one
server the database is on drive C: but on the other server, the databases
need to be on Drive D:. If this is the case, then you need to be sure to
do a "With Move" when restoring. If the files are on the same drive, that
should be ok. Also, if the files already exist, you may have to use the
"With Replace" to overwrite the existing files.

These are two of the most common problems when restoring databases on
different servers. There are other possible issues. For example, the
logins in the database do not match the logins on the server. You can
determine this if you run:

 sp_change_Users_login 'Report'

If you get results, then the logins in the results have permission to the
database, but do not have a matching login on the server. These should be
corrected. If you run this procedure and get no results, this means that
all logins for the database having matching logins for the server.

2. Specifically, I have the recovery model set to simple. Will this be
included in the restore?

>>>>>>This should be included with the restore.

Hope this helps!:)

Sincerely,

Rob Beene, MCSD, MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

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)