Friday, March 30, 2012

restore db with script?

Hi all.
I have a sql server backup file for SQL Server 2000.
Is there a way to bring this file to another computer with SQL and run a
script that tells the server to restore the backup file automatically
without using the GUI?
Thanks in advance.Yes, on the target machine, schedule a T-sql job to run a restore command,
see restore syntax in BOL.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Daniel" <dhw377@.nothing.no.spam.com> wrote in message
news:pHYMb.1223$ZJ1.790@.lakeread01...
> Hi all.
> I have a sql server backup file for SQL Server 2000.
> Is there a way to bring this file to another computer with SQL and run a
> script that tells the server to restore the backup file automatically
> without using the GUI?
>
> Thanks in advance.
>

No comments:

Post a Comment