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 |
|
aclarke
Posting Yak Master
133 Posts |
 Posted - 2007-05-21 : 18:39:33
|
| Hi. I have a client with a database hosted on SQL Server 2005. I don't have a paid version of SQL Server at home so am just using SQL Server Express. I'm getting INCREDIBLY FRUSTRATED that I can't use the "copy database" wizard from SQL Server Express.Am I just out of luck on this? I can't use the "copy database" feature since I'm using Express. I can't get the actual files since the database is on a shared server. I know I'm not the only person with this issue; I see people asking the question but I don't see any answers.Is there any way I can copy this database?Thank you very very much,- Andrew Clarke. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-21 : 18:47:16
|
| Can't you contact the hoster for a copy of the backup file? It's your data, so you own it. Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
aclarke
Posting Yak Master
133 Posts |
Posted - 2007-05-21 : 22:50:14
|
quote:
Originally posted by tkizer
Can't you contact the hoster for a copy of the backup file? It's your data, so you own it. Tara Kizerhttp://weblogs.sqlteam.com/tarad/
Thanks for the response. It's my client's data, not mine, but probably the hosting company would provide that, maybe for a fee. That doesn't help me next week when I need the same thing though, and the week after that!I could write scripts to copy the database, but it just seems like there ought to be a better solution. Would installing the SQL Server 2000 client let me copy the database using DTS?Thanks,- Andrew. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 23:42:04
|
| Don't think copy db wizard will work since it has to detach the db, can try with ssis. But is there security issue to copy your client's db to your home pc? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-22 : 01:57:26
|
| "I don't have a paid version of SQL Server at home so am just using SQL Server Express"The Developer version is very cheap. Just a thought.Kristen |
|
|
|
aclarke
Posting Yak Master
133 Posts |
Posted - 2007-05-22 : 09:36:15
|
quote:
Originally posted by KristenThe Developer version is very cheap. Just a thought.
Hmm, you're right it's only US$50. Probably worth buying. I'd started looking up the price yesterday and got sidetracked.Thanks,- Andrew. |
|
|
|
|
|
|
|
|
Copying a database from web host