Friday, March 9, 2012

restore backup

I have a copy of a database to install and work with locally (work from my
own pc at home instead of in the office). I have a copy of the bak file, how
can I install that on my SQL Server and use the database?
NuB,
Use either Enterprise Manager - Restore or the T-SQL RESTORE statement.
See:
'How to restore a backup from a backup device (Enterprise Manager)' in the
SQL Books Online
or
'RESTORE' in the SQL Books Online. (examples included)
HTH
Jerry
"NuB" <me@.me.com> wrote in message
news:eKQGG5L2FHA.2932@.TK2MSFTNGP10.phx.gbl...
>I have a copy of a database to install and work with locally (work from my
>own pc at home instead of in the office). I have a copy of the bak file,
>how can I install that on my SQL Server and use the database?
>
>

No comments:

Post a Comment