|
Posted by Jack Vamvas on 04/05/06 11:46
Yes, use : RESTORE DATABASE MyNwind FROM MyNwind_1 (i've taken this from
BOL) for more involved examples check BOL
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
<kskartsiounis@yahoo.com> wrote in message
news:1144224541.969405.253280@g10g2000cwb.googlegroups.com...
> I recently had to find ways to programmatically backup and restore an
> SQL Server Express database.
> For backup, I found a one-liner stored procedure that does the job
> (BACKUP DATABASE Toy to disk = 'c:\Projects\Toy.bak'.
> My question is, is there something as simple for a restore operation?
>
> Thanks in Advance
>
> -Kostas
>
Navigation:
[Reply to this message]
|