November 4, 2010 at 12:49 pm
How do I copy a database and all it's properties including data to another database? Any suggestion will be appreciated.
November 4, 2010 at 12:50 pm
You could use backup and restore.
November 4, 2010 at 12:52 pm
My vote is for backup and restore.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 1:03 pm
Backing up the current database and restoring it to the new database?
November 4, 2010 at 1:05 pm
Yes
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 1:30 pm
I get this errors while trying to restore to the new database:
"Restore failed for sqlserver 'Servername"
"System.data.sqlclient.sqlerror: The backup set holds abackup of a database other than the existing 'newdatabase' database"
Please help!
November 4, 2010 at 2:52 pm
Let's step back - what is the state of both databases? Are these two databases already in existence and do they serve production data?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 3:01 pm
Hi Jason,
I got it situated now. I was probably doing the wrong thing. Thanks for your help 🙂
November 4, 2010 at 3:17 pm
You're welcome. Thanks for posting back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply