Restoring Database using Transact SQL

[SilentWings]

Hi ppl,
I have a transact sql that create a database. It works.
Then I need to put the database on the server.
I need a transact sql that restores a complete database that I have saved in a folder imagine 'c:\tem\mydb.bck'
Can you give-me that TSQL?
Note: The server where I am restoring the database never had this database on it.

Thanks in advance

 

[mrdenny]

restore database {database_name} from disk='c:\tem\mydb.bck'

See restore database in BOL for full syntax options.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

For your information:

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

-SQLBill