Backup and restore

We are using SQL Server 2005.
To do db backup and restore from 1 machine to another, do I need to already
have the database created on the 2nd machine ? Do I need to have the tables
and stored procedures and views created already on the 2nd machine ?
Thank you
Hi,
You do not need to create anything on the second server. Just restore the
database from your backup files and the database and everything inside
(tables, stored procedures, views, etc.) will be created for you.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"fniles" wrote:

> We are using SQL Server 2005.
> To do db backup and restore from 1 machine to another, do I need to already
> have the database created on the 2nd machine ? Do I need to have the tables
> and stored procedures and views created already on the 2nd machine ?
> Thank you
>
>