hello,
I have my database server environment on the same pc where i have my
development environment because i am still in the testing mode, but when i
want to switch to the production mode, i want to install my db server on a
separate computer so that clients can use the application. The question is,
can i move or transfer the database that i built on the first computer to the
other computer without redesigning it and rebuilding it from groud
up(inserting the data) especially that the database is somehow big.

You can use BACKUP and RESTORE or sp_detach_db and sp_attach_db. It is
important to backup your database at least daily and put it on tape, another
computer's hard drive, or CD/DVD ROM. This will help you recover from a
complete hardware failure.

--
Keith


"Philip Germanos" <PhilipGermanos@discussions.microsoft.com> wrote in
message news:6B937F31-9D87-4F69-B779-735D0C9F814E@microsoft.com...
[quoted text, click to view]

Hi Philip
you have 3 options
backupthe current db and restore on new prod server
do sp_attach and sp_detach
use copy database wizard.

HTH
Nikhil
"Philip Germanos" <PhilipGermanos@discussions.microsoft.com> wrote in
message news:6B937F31-9D87-4F69-B779-735D0C9F814E@microsoft.com...
[quoted text, click to view]