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?
Thanks
If 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...b;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

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/defaul...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?
> Thankssql

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

Installation Problem

I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP. Since XP is client, it greys out option to install on a remote server. Help and directions to resolve install would be appreciated, TKS
>
> I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP.
> Since XP is client, it greys out option to install on a remote server.
> Help and directions to resolve install would be appreciated, TKS
>
This is by design.
Windows NT 4.0 workstation, Windows 2000 professional and Windows XP home
and professional editions do not support a remote server install.
You need a server edition installation to do a remote install.
Hope this helps,
Eric Crdenas
SQL Server senior support professional

Installation Problem

I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP. Since XP is client, it greys out option to install on a remote server. Help and directions to resolve install would be appreciated, TKS>
> I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP.
> Since XP is client, it greys out option to install on a remote server.
> Help and directions to resolve install would be appreciated, TKS
>
--
This is by design.
Windows NT 4.0 workstation, Windows 2000 professional and Windows XP home
and professional editions do not support a remote server install.
You need a server edition installation to do a remote install.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional

Installation Problem

I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP. Sinc
e XP is client, it greys out option to install on a remote server. Help and
directions to resolve install would be appreciated, TKS>
> I am trying to install MS SQL2000 onto a remote WinServ2003 from an XP.
> Since XP is client, it greys out option to install on a remote server.
> Help and directions to resolve install would be appreciated, TKS
>
--
This is by design.
Windows NT 4.0 workstation, Windows 2000 professional and Windows XP home
and professional editions do not support a remote server install.
You need a server edition installation to do a remote install.
Hope this helps,
Eric Crdenas
SQL Server senior support professional

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
ThanksPeter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegroups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>

Installation Error

I am installing Reporting Services on a Domain Controller,
Windows Server 2003. The database needs to be a remote
database. I am using a sql server login that is a dbowner
of the master database. I keep getting an error when it
tries to configure the databases. In the error log it
says that "ReportServer" database can not be created.
I get error "1603" and then it rollsback the installation.
Please Help!You might be running into the issue where SQL has no default path for
creating DBs. Check on the properties tab for the SQL server instance you
are installing to. Under Database Settings is a place to put a default
path. You can also pass the location in on the command line using:
RSDATABASEFILELOCATION and RSDATABASELOGFILELOCATION.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcia Gorby" <anonymous@.discussions.microsoft.com> wrote in message
news:338001c47112$b5a13ed0$a501280a@.phx.gbl...
> I am installing Reporting Services on a Domain Controller,
> Windows Server 2003. The database needs to be a remote
> database. I am using a sql server login that is a dbowner
> of the master database. I keep getting an error when it
> tries to configure the databases. In the error log it
> says that "ReportServer" database can not be created.
> I get error "1603" and then it rollsback the installation.
> Please Help!