Click here to Skip to main content
15,943,406 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
How to schedule a daily db restore on a windows shared hosting...
As I figured out, with a rollback it cant be done, because I would have to create the whole db and fill the tables in the transaction, which isnt possible because a transaction doesnt allow multistate statements ... ... ...

Than I tried to create a sqlcmd script, but the problem isnt to download the backup from the server, its the restoration of the db from the backup on the server.

I am using a windows shared hosting, mssql server 2008
Posted

1 solution

A full backup would have to be done
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900