|
Home > Archive > MS SQL Server > October 2006 > How to restore database with Move
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to restore database with Move
|
|
| Stephen K. Miyasato 2006-10-24, 6:37 pm |
| I have back up my database on one machine using backup and wish to confirm
that I can restore this on another server.
how do I use Restore with Move?
Thanks
Stephen K. Miyasato
| |
| Paul Ibison 2006-10-24, 6:37 pm |
| Stephen,the syntax in MSDN2 is explained under the heading of 'Restore' but
the example shows a norecovery followed by a recovery which is probably more
complicated than you require. Anyway, I've edited the example syntax and
scripted it below:RESTORE DATABASE AdventureWorks
FROM AdventureWorksBackup
s
WITH RECOVERY,
MOVE 'AdventureWorks_Data
' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\Data\NewAdvW
orks.mdf',
MOVE 'AdventureWorks_Log'
TO 'C:\Program Files\Microsoft SQL
Server\MSSQL. 1\MSSQL\Data\NewAdvW
orks.ldf' Cheers, Paul Ibison
SQL Server MVP, www.replicationanswers.com .
| |
| Arnie Rowland 2006-10-24, 6:37 pm |
| For a good discussion, lookup RESTORE in Books Online. There is a lot of
detail, and examples; look at Example D.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stephen K. Miyasato" <miyasat@flex.com> wrote in message
news:%23m1kXP87GHA.4304@TK2MSFTNGP03.phx.gbl...
>I have back up my database on one machine using backup and wish to confirm
>that I can restore this on another server.
>
> how do I use Restore with Move?
>
> Thanks
>
> Stephen K. Miyasato
>
|
|
|
|
|