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 |
|
pmg
Starting Member
2 Posts |
 Posted - 2007-03-14 : 15:23:15
|
| Hi all,I'm using shared sql space on a new provider and am trying to import a database backup file - of the format filename.db.I cannot figure out how to import this file type using the 2005 express tools - I can connect to the database and create and drop tables alright, but I cannot just import the existing database.I really haven't got the time on my connection to download the fully blown SQL server trial to be able to do this, so can anyone help me out with any easier solutions?Cheers, Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-14 : 15:34:34
|
| You need to find out if filename.db is a valid SQL Server backup, if its the MDF file, or if some other backup program was used to create it. Once we know that information, we can tell you how to import it.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pmg
Starting Member
2 Posts |
Posted - 2007-03-14 : 15:41:02
|
| Hi!I believe it's the SQL server backup, I'm unsure why they've used a .db extension however, that's what's thrown me as I can't find any information on that particular file extension. Put it this way: I was able to restore the database via a handy web interface to another provider using it, this is now a dedicated server however so case of needing the tools to do the job myself. Thank you so much for taking the time to reply - if there's anything else I'm being vague about let me know and I'll sort it.Cheers, Mike |
|
|
|
|
|
|
Importing DB backup file to SQL Server 2005