Copy db and create new db from it (sql 2005)
I have a sql 2005 express database which I'd like to copy entirely into
a new database. IOW create Database2 as a complete, one time copy of
Database1.
It's easy to script database1, but that's just the db. The tables and
sprocs etc don't come over with that. A backup of database1 can't be
restored to database2. So how does one do it?
.
Relevant Pages
- Crystal report 9 How can i switch between 2 database location ?
... A report is generated against database1 ... when is change the data source location to another database2. ... te be willing but whe i use the option show sql the old database1 is till ...
(microsoft.public.vb.crystal) - Extrating Data from One Database from Another
... I am new to sql. ... let's call it database1 and database2. ... Database1 has approximatley 12000 records and database2 has approximately ... Steve, ...
(microsoft.public.sqlserver.mseq) - Re: Restore a backup to a different db name and path
... Hitchhiker's Guide to SQL Server 2005 Compact Edition ... Database1 on my sql server with the following path: C:\DBs ... I made a backup of this database. ... allow me to restore a db and rename the path and file name. ...
(microsoft.public.sqlserver.msde) - Re: restore transaction log
... Did you backup the log of database1? ... > RESTORE LOG DATABASE1 ... > No entry in sysdevices for backup device 'DATABASE1_Log'. ...
(microsoft.public.sqlserver.programming) - Restore a backup to a different db name and path
... Database1 on my sql server with the following path: C:\DBs ... I made a backup of this database. ... allow me to restore a db and rename the path and file name. ...
(microsoft.public.sqlserver) |
|
