What is the fastest method to create a new database from a template ?

Posted by Locksfree on Stack Overflow See other posts from Stack Overflow or by Locksfree
Published on 2010-03-24T08:36:33Z Indexed on 2010/03/24 8:43 UTC
Read the original article Hit count: 256

Filed under:

mssql

|

database-restore

We are creating databases on demand and the databases can be created from different templates. All templates have the same structure but different data. The data contained by the templates is small.

What is the fastest way to create a copy of the database:

Backup/Restore
1. Using T-SQL ?
2. Using SMO ?
Create a new database from a scripted version of the template and then fill in the little data required ?
Other ?

© Stack Overflow or respective owner

Related posts about mssql

Fixing my SQL Directory NTFS ACLS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after… >>> More
Restore Database from MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Recover Data Entered in MSSql 2008 to MSSql 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello... I have created a set of tables (around 20) in MSSql 2008 and entered around 1000 records to appropriate tables. But the issue is that I want that same tables with all the entered data into MSSql 2005 (SQLEXPRESS). Obviously it won't work by taking a backup and restore it into MSSql 2005… >>> More
Plans for our next milestone

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We have seen some increase in activity with more people downloading our driver and either reporting their successes or reporting any issues they run into – for the native driver (sqlsrv_xxxx API) to the PDO driver (PDO API). We’d like to thank you all for your effort and hope that our… >>> More
SQL Server Driver for PHP 2.0 CTP2 is now released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
digg_url = "http://blogs.msdn.com/b/sqlphp/archive/2010/06/15/sql-server-driver-for-php-2-0-ctp2-is-now-released.aspx";digg_title = "SQL Server Driver for PHP 2.0 CTP2 is now released";digg_bgcolor = "#FFFFFF";digg_skin = "normal"; digg_url = undefined;digg_title… >>> More

Related posts about database-restore

Database operations through SQL: Database Restore ...

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments. with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' If logical file name… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
Undo Database Restore in SQL Server 2008

as seen on Server Fault - Search for 'Server Fault'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? -Vivek >>> More
Restore SQL Server 2008 db without affecting users

as seen on Server Fault - Search for 'Server Fault'
When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA is properly mapped to the right Windows user in the database. After the Restore, Web_SqlA is still… >>> More
Undo Database Restore in SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? >>> More