how to duplicate my database?

Hello guys
I have to do a demo and I need to bring my database with me...how can I do
that. I have ms sql server 2000. Is there a way of executing a script or
something?
ThanksNaby wrote:

> I have to do a demo and I need to bring my database with me...how can
> I do that. I have ms sql server 2000. Is there a way of executing a
> script or something?
What I do is take a backup and restore that on the demo machine.
Fastest way to do it I think.
HTH,
Stijn Verrept.|||Dettach database copy/paste mdf and ldf file and attach.
This requires downtime.
But its better if you want to do it fast then to backup database and
restore it at other location
Regards|||Hi Naby,
you can Generate SQL scripts with help of enterprise manager. It will
create a scripts which will contain all tables, view, procedure, defaults an
d
rules of your database, you also customize the option in generating this
script .
with help of the script, you create same tables, procedures and all
present in the scripts. but data will not be there. To have data, Use DTS
transfer the data to text file and after running the scritps transfer the
data in text to database.
regards
Vinod.
"Naby" wrote:

> Hello guys
> I have to do a demo and I need to bring my database with me...how can I do
> that. I have ms sql server 2000. Is there a way of executing a script or
> something?
> Thanks|||You have to take care of order of tabled due to constraints while using
dts , its more tedious work
or you have to disable constraints that is not good idea for live
database.
Regards
Amish|||The following article describes various methods for implementing a standby
server, but some of them would also apply in your case:
http://vyaskn.tripod.com/maintainin..._sql_server.htm
One option the above article doesn't mention is detach / copy / reattaching
the database files:
http://support.microsoft.com/kb/224071
You didn't say if SQL Server is installed on your laptop, but the MSDE
version is one option:
http://www.microsoft.com/sql/editio...ss/default.mspx
"Naby" <Naby@.discussions.microsoft.com> wrote in message
news:459F468F-F207-4FBF-A289-13091612A185@.microsoft.com...
> Hello guys
> I have to do a demo and I need to bring my database with me...how can I do
> that. I have ms sql server 2000. Is there a way of executing a script or
> something?
> Thanks