MS SQL Server New Users

Author

SQL Restores

NOBI

2005-05-20, 9:23 am

I have used my enterprise manager to automatically backup SQL databases but
am a little unclear on how to restore. I would like to do test restores to an
alternate location so as not to interfere with daily operations. Any help or
recommended reading would be appreciated.

Thanks

Hari Prasad

2005-05-20, 9:23 am

Hi,

Have a look into the below article. For Restore see the Restore
methedologies part.

http://www.microsoft.com/india/msdn/articles/185.aspx

Thanks
Hari
SQL Server MVP

"NOBI" <NOBI@discussions.microsoft.com> wrote in message
news:F6615511-5059-43E4-ACFA- B2B4D3292606@microso
ft.com...
>I have used my enterprise manager to automatically backup SQL databases but
> am a little unclear on how to restore. I would like to do test restores to
> an
> alternate location so as not to interfere with daily operations. Any help
> or
> recommended reading would be appreciated.
>
> Thanks

Nik

2005-05-25, 8:24 pm

Same way you do your backup,
Do you want to use GUI or sql command
using GUI is e z,
here are the steps
Right Click the database you want to restore
All task, restore,
In the restore as db select the db you want, i am assuming that you hjave a
..bak file somewhere on some mapped drive,
then select from device fom server
Go to Options
Select leve db operational.
from sql prompt

BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'

Do a search on RESTORE (described) in BOL

hth
Select the bak location on

"NOBI" <NOBI@discussions.microsoft.com> wrote in message
news:F6615511-5059-43E4-ACFA- B2B4D3292606@microso
ft.com...
> I have used my enterprise manager to automatically backup SQL databases
but
> am a little unclear on how to restore. I would like to do test restores to
an
> alternate location so as not to interfere with daily operations. Any help
or
> recommended reading would be appreciated.
>
> Thanks

Sponsored Links