在共享的Windows主机上安排还原数据库 [英] schedule restore database on shared windows hosting

问题描述

如何在Windows共享主机上安排每日数据库还原...
如我所知，使用回滚是无法完成的，因为我将不得不创建整个数据库并填充事务中的表，这是不可能的，因为事务不允许多状态语句……...

比我尝试创建sqlcmd脚本要多，但问题不是从服务器下载备份，而是从服务器上的备份还原数据库.

我正在使用Windows共享主机，mssql服务器2008

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

推荐答案

必须完成完整备份

这篇关于在共享的Windows主机上安排还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！