Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshsql
Starting Member
17 Posts |
 Posted - 2006-11-09 : 06:57:09
|
| Hi,I want to create two databases by restoring from asingle backup file in sql server. I am using 2005-sqlexpress .Is it possible?Thanx in advance.. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-09 : 07:25:23
|
no.you'd have to restore to one database and then split that db in twoGo with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
samuelclay
Yak Posting Veteran
71 Posts |
Posted - 2006-11-09 : 16:26:15
|
| hmmm, why would you split them? Maybe I read it differently, but it sounded like he wanted identical copies of the database. Many times I have used a single backup file (from production) to create multiple (dev and test) databases on my local machine(not using express). This seems to be questioning the limits of SQL express. Does it limit you to a single data base? I believe it does, but you can install multiple instances. So, you would have to install an instance fore each copy you wanted to make. |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-11-12 : 17:30:44
|
| You can have all the databases on Express as you like (but none can be more than 4GB) and you can restore a backup into as many 'new' databases as you like.-- Alice came to a fork in the road. "Which road do I take?" she asked. "Where do you want to go?" responded the Cheshire cat. "I don't know," Alice answered. "Then," said the cat, "it doesn't matter." |
|
|
|
|
|
|
Creating multiple databases from a single backup f