Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks