| Author |
Restore to a Different Database
|
|
|
| I have backed up our production database to a file and would like to restore
it to a test database I created. This seems very simple but I seem to be
missing something. I am using query analyzer. Could someone please assist
me?
TIA
TR
| |
| Tibor Karaszi 2006-10-24, 6:29 pm |
| 1. You don't have to create the database before RESTORE. The restore process will do it for you.
Pay special care of the MOVE and REPLACE options of the RESTORE command.
In case you don't succeed with the restore, please post the RESTORE command and the error message(s)
returned by the database engine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"TRD" <tdejohnx2@hotmail.com> wrote in message news:%23GZjg512GHA.1548@TK2MSFTNGP02.phx.gbl...
>I have backed up our production database to a file and would like to restore it to a test database
>I created. This seems very simple but I seem to be missing something. I am using query analyzer.
>Could someone please assist me?
>
>
> TIA
> TR
>
| |
|
| just restore the database from the backup file as suggested. First delete
the test database and then make sure you name the new database and select
from Device as it will then allow you to browse to your backup file from the
source database. Just right click from enterprise manager and select all
tasks/restore database.
--
Paul G
Software engineer.
"TRD" wrote:
> I have backed up our production database to a file and would like to restore
> it to a test database I created. This seems very simple but I seem to be
> missing something. I am using query analyzer. Could someone please assist
> me?
>
>
> TIA
> TR
>
>
>
| |
|
| Thanks for the help.
"Paul" <Paul@discussions.microsoft.com> wrote in message
news:3379D7D1-01CA-4617-A54B- EEBFF56631AB@microso
ft.com...[color=darkred]
> just restore the database from the backup file as suggested. First delete
> the test database and then make sure you name the new database and select
> from Device as it will then allow you to browse to your backup file from
> the
> source database. Just right click from enterprise manager and select all
> tasks/restore database.
>
> --
> Paul G
> Software engineer.
>
>
> "TRD" wrote:
>
|
|
|
|