Backup and Restore - from Test to Prod Environment

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: JD (jd_at_associates.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 09:06:29 -0600

We have an SPS server for test and production - both SPS installations have
their own separate SQL server.

My goal is to backup the SQL databases using SQL Enterprise Manager on a
scheduled task in both TEST and PRODUCTION.

Question:

(1) Can I restore the same database from TEST to PROD - EVEN if the
Database name in SQL are different? Actual data and Tables are same,
accounts used are same, ONLY difference is the databse names.

(2) What is the best way or alternative to accomplish what I am trying to
do - RESTORE TEST to PRODUCTION with different database name but same
content?

(3) Is the SPS Backup tool only for the database/SPS server it was ran on -
meaning - can I do the restore to another SPS Server - or does it have to be
the same server I backed up from?

Thanks!

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)