Move Database

Hi
We are running RMS Server and the SQL in the same server (only for RMS), we
like to seperate the SQL in to other server. (just RMS will be in the same
server and settings, except SQL database).
How we do that? just simply take backup and restore? or anything we have to
do?
Thanx
Gopi
Gopi
http://support.microsoft.com/default...n-us;Q314546#9 -- Move
Databases between computers running by sql server
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
> Hi
> We are running RMS Server and the SQL in the same server (only for RMS),
> we like to seperate the SQL in to other server. (just RMS will be in the
> same server and settings, except SQL database).
> How we do that? just simply take backup and restore? or anything we have
> to do?
> Thanx
> Gopi
>
|||Thanx Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OBfvxcCxFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Gopi
> http://support.microsoft.com/default...n-us;Q314546#9 --
> Move Databases between computers running by sql server
>
>
>
> "Gopi" <gopigopi@.hotmail.com> wrote in message
> news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
>
|||Try a backup and restore. The run sp_change_users_login as necessary.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi
Check out http://support.microsoft.com/default...;en-us;Q314546
for the various methods. Watch out for orphaned users as described in the
article.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi,
1. Backup the database from source sql server using (BACKUP DATABASE
command)
2. COpy the backup file to test server
3. Restore the database in test server (RESTORE DATABASE)
See Backup and Restore commad in books online.
Note:
You can also detach and attach databases. It is fast but require some down
time .
Thanks
Hari
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi Hari, does Backup/Restore copy the table structure and constrains too?
There is no tables crated in the destination database.
Thanks,
"Hari Prasad" wrote:

> Hi,
>
> 1. Backup the database from source sql server using (BACKUP DATABASE
> command)
> 2. COpy the backup file to test server
> 3. Restore the database in test server (RESTORE DATABASE)
>
> See Backup and Restore commad in books online.
> Note:
> You can also detach and attach databases. It is fast but require some down
> time .
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
>
>
|||Hi
It is a backup of everything, read more about backup/restore in Books
online. You should have a policy that says you backup your database at
specific times and save them on external media so that in the event of a
system failure you can recover they system to a given level.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:BF9B75D0-5DAE-4922-B64B-8177FC0D0993@.microsoft.com...[vbcol=seagreen]
> Hi Hari, does Backup/Restore copy the table structure and constrains too?
> There is no tables crated in the destination database.
> Thanks,
> "Hari Prasad" wrote: