Clone db from server to other server
Clone db from server a tomserver b without genarating a bk file
Direct bk restor without generating file
This alow to save time and space
Ahmed rouani
shared this idea
-
Ahmed rouani
commented
Thanks.. really interesting.
-
philcart
commented
Ahmed, what you're looking for is probably best done at SAN level. With something like FlexClone from NetApp. See this article,
http://www.netapp.com/au/solutions/applications/microsoft-sql/ms-sql-test-dev.aspx -
Ahmed rouani
commented
Yes good idea,
But why not by using Red Gate backup soft and create a new DB on any server from any existing DB.
I want to do this without BK-RESTOE by using files.
Why create a file and then read it again.
I want to save TIME + SPACE.
I have 280Gb DB , it takes 1 hour to BK it + 1h:30 to restore IT with REDGATE. Why not having all this on 1h: 30 and without the need for the 30Gb BK file. -
Are you hoping for a way of right clicking on a database in SSMS and finding an option to "Create new database from this one"?
-
philcart
commented
This is not something for SQL Source Control. Maybe more appropriate for SQL Backup Pro.
