Wednesday, March 28, 2012

restore db

Hi, I have two file: db_mydb and db_mydb.BAK.
how to restore it to a new server? Thansk.RESTORE DATABASE db_mydb FROM db_mydb(assuming db_mydb is a BAK file)
--
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"js" <js@.someone.com> wrote in message
news:%23kbPhZZLGHA.668@.TK2MSFTNGP11.phx.gbl...
> Hi, I have two file: db_mydb and db_mydb.BAK.
> how to restore it to a new server? Thansk.
>

No comments:

Post a Comment