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 |
|
monfu
Yak Posting Veteran
81 Posts |
 Posted - 2008-09-24 : 04:02:01
|
| Dear All,I have a hosting account with a hosting company, and I have an SQL database hosted with them. My problem is that every time I have to backup the database, or upload a backup to restore the database, I have to ask them to do it, and it could take 8 hours before they reply.Is it possible to create some sort of script or SSIS package, to move the data from the server back and forth for example every day? I was thinking about the Import/Export option, however I am not aware if there is maybe something simpler than that.Thanks for your helpJohann |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 04:10:28
|
| You mean storing each days table data onto some snapshot like table? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 04:14:05
|
| You could use database maintainence wizard to schedule backup and restore of your db.http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EOE |
|
|
|
|
|
|
backup database data on the server