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 |
|
logotype
Starting Member
3 Posts |
 Posted - 2007-05-23 : 08:35:01
|
| HelloI am trying to backup all our databases from a hosted environment to our own servers.1. Transfer database doesnt work (im not dbo, not sysadmin).2. Script database doesnt work (no acces to DBCC SHOWFILESTATS)3. Backup doesnt work (no access).My only option is to open a DB, select every table and script them, after that, copying all data per table. DB-per-DB. Is there another way? (it'll take some serious time when having 100+ DBs).Best regards,Victor |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-23 : 10:44:50
|
| Can you ask your hosting company send you db backup files? |
 |
|
|
logotype
Starting Member
3 Posts |
Posted - 2007-05-24 : 08:00:03
|
quote:
Originally posted by rmiao
Can you ask your hosting company send you db backup files?
Yes, but they does not send the db files (not even if we are paying them). It seems like this hosting company sucks :)Thank you for your reply.But it would be great if it is possible to export all databases, my thought is to use "transfer database" without the use of "DBCC SHOWFILESTATS", but I don't know how... |
|
|
|
|
|
|
Script database in hosted environment problem