Re: Setting up Test of database using backup/restore

From: Monty (montysl_at_nospam.hotmail.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 11:29:08 -0500

Thanks Andrew...I have seen the references in your other posts but I just
want to make sure the testing version will not in any way interfere with my
production DB. The references seem to assume a move of an active DB to other
hardware/OS/version platforms with the intention of making them active right
away and never the concurrent running of the 2 DB's. Now, to be clear, never
will the two be in production at one time, all production code will point
toward the SQL7 instance and test code toward the 2000 test until time to
make a full changeover but you get what I mean. Is this method still okay?
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:erXXwwKeEHA.384@TK2MSFTNGP10.phx.gbl...
> I would go for the restore of the latest FULL backups as the least
intrusive
> way to accomplish this. Here are some links that may help:
>
>
> http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Monty" <montysl@nospam.hotmail.com> wrote in message
> news:%23B8M9rKeEHA.3928@TK2MSFTNGP11.phx.gbl...
> > Hope this is simple....time constraints. I need to copy a fully
functional
> > SQL7 DB on a W2K server over to a SQL2000 install on a W2K3 server for
> > testing ONLY at this point. The SQL7 DB needs to remain active and
> > completely intact, if at all possible, during the procedure. I have good
> > backups of all DB's (user, master, etc.) Can I simply restore these to
the
> > SQL2000 install and proceed with testing?
> >
> > Thanks in advance.
> >
> >
>
>

Relevant Pages

  • Re: Setting up Test of database using backup/restore
    ... A backup and restore does not interfere with the production server at all. ... >> Passwords Between SQL Servers ... >> Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: Best Way for restoring AD in a test lab
    ... Well do a backup and restore following most of the procedures outlined. ... Just do a backup on a production dc. ... > DC to the test lab with the same Server Name and this is our DR process. ... >> Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Best Way for restoring AD in a test lab
    ... I promo a machine in production, back it up and demote it. ... protected space and restore it and whah lah I have a system up and running. ... "Directory Services Restore Mode (Windows 2000 domain controllers only)" ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Database restore, both from same and different server
    ... Production WSS is working, but a web part has a memory leak. ... production to a development server. ... I've had all kinds of problems trying to restore this ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Is useful the parallel development-production schema with Sharepo
    ... deploying of functional changes only (webparts, ... backup from production to development for taking the last ... >on a seperate server. ... >There isnt an increment restore - or a delta restore ...
    (microsoft.public.sharepoint.portalserver)
Loading