SQL Server 2008: How to clone an entire Database onto a new server?

Question

I'm running SQL Server 2008, I want to create an entire copy of my Database, all my tables, views & stored procedures. How do I do that?

Ideally copy to a flat file or something like that then import on my new server.

Backup/restore, detach/attach, and all the flavors of replcation will do it... or did you only want the "database objects", without the actual data? — Philip Kelley
– Philip Kelley, Commented Jun 29, 2011 at 19:04

sll · Accepted Answer · 2011-06-29 18:40:30Z

5

MSDN: Backup and Restore database ?

With Screenshots: see here

answered Jun 29, 2011 at 18:40

sll

62.7k22 gold badges109 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

retrodrone · Accepted Answer · 2011-06-29 18:46:17Z

Is this a one-time copy operation, or do you want it to be an ongoing replication of transactions to the destination server?

If it's the latter option, you can export and ship the transaction logs, which requires much less bandwidth per unit time than shipping a backup of the database. See this for details. I've had great success with this method using SQL Server 2008 R2 Express.

You can still use transaction logs if it's a one-time operation, but it may not be worth the up-front investment in time developing the scripts. In that case, see How to move databases between computers that are running SQL Server.

Collectives™ on Stack Overflow

SQL Server 2008: How to clone an entire Database onto a new server?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related