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 |
|
token
Posting Yak Master
133 Posts |
 Posted - 2005-12-02 : 11:11:07
|
| hi all,I'm having real trouble trying to place another copy of my database on a different computer.I have developed a database on my main PC. But I want another copy of this same database to reside on my laptop so that I can do work on the move.So far no luck. I installed SQL Server on the laptop but it won't let me create a database based on an existing database file.Any ideas guys?cheers,token |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-02 : 11:29:50
|
| BACKUP from the existing server, RESTORE onto your laptop. The target database doesn't need to pre-exist on the laptop.(You may then have to reinstate the Users - ask if you get stuck at that point - preferably BEFORE you attempt to fix it up!)Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-03 : 01:31:16
|
| http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546>>The target database doesn't need to pre-exist on the laptop.If we use Restore Command then the target database should exist although the name does not necessarily same. Am I right?MadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-03 : 02:32:24
|
| "If we use Restore Command then the target database should exist"You can restore, from a backup file, into a database that doesn't yet exist.Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-03 : 03:13:24
|
>>You can restore, from a backup file, into a database that doesn't yet exist.Thanks. I always used to create Database and Restore it  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
moving database to another computer