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 |
|
griffinmt
Starting Member
3 Posts |
 Posted - 2008-09-05 : 10:41:30
|
| I had a database on one of my computers, running with MSDE.After having some 'technical' issues with that machine, I installed MSDE on another system. Although the original system won't run now, I have the mdf/ldf files for the database that I can restore to this second system.How can I 'import' this sizeable database into the new system? I have tried the create database xxxx on primary ......It did not report any errors but it seems that it did not work. The only tool I have for working with this is SQLCMD. I have much more comfort working with MySql but that is another story!Martyn |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-05 : 12:31:09
|
| Try attaching the database files. If you need to do this through command line, you would use sp_attach_db or sp_attach_single_file via osql.exe.You can also attach through the GUI, but I'm not sure if you've installed any SQL client tools since MSDE doesn't come with any.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
griffinmt
Starting Member
3 Posts |
Posted - 2008-09-05 : 13:51:21
|
I managed to get the db attached with sp_attach_db and specifying the correct parameters this time. Thanks for the response, and now I like MySql even better!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-05 : 13:53:28
|
| You'd be much happier with SQL Server if you upgraded to a more recent version, such as SQL Server 2005 Express (free like MSDE). You should also check out what SQL Server 2008 has to offer.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
griffinmt
Starting Member
3 Posts |
Posted - 2008-09-05 : 15:11:29
|
| I would upgrade under normal circumstances, but this is part of an application for which I do not have the source, so it is unclear if it would function appropriately if not MSDE. Vista is NOT in my plans over the next short time that I have to have this app working.Anyway, now the app is working as expected on the new system.Thanks |
|
|
|
|
|
|
Migrating Database