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 |
|
fabianus76
Posting Yak Master
191 Posts |
 Posted - 2005-10-03 : 12:06:33
|
| Hallo!I would like to create a backup file in SQP-Server Express and restor this backup-file in SQL-Server 2000. I am looking for the command that produces the .bak-file. Thank you very much!Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-04 : 13:23:19
|
| You can't backup a database in 2005 and restore it in 2000. You can go the other way around though, from 2000 to 2005.Tara |
 |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2005-10-04 : 14:33:48
|
| Hallo Tara, thank you for help!In fact I discovered that I do not have the rights to restor a db on the sql-server of my hoster. So I have a new question :-) How may I export data from my local sql-server (2005) and import it into the sql-server (2000) of my hoster? For example I could create an sql-file with all table and data info and then put it into the db at my hoster - but how to do this?Thank you for any help!Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-04 : 15:57:08
|
| You can use Integration Services, which is the DTS replacement in 2005. I don't have any details on IS as I haven't used it.Tara |
|
|
|
|
|
|
create a backup file and restor in SQL-Server 2000