# SQL Server Backup and Restore

**URL:** <https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261>\
**Category:** Discussion\
**Created:** [December 11, 2006, 10:50am UTC](https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261 "2006-12-11T10:50:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![deleted\_user](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/deleted_user/32/937_2.png) [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)\
**Post date:** [December 11, 2006, 10:50am UTC](https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261/1 "2006-12-11T10:50:09Z")

</div>

Hello,How can I do a database restore using Automise? IIRC, backups are possible, but not restores.Thanks!

---

<div class="post-metadata">

**Author:** ![tate](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/t/e19b73/32.png) [@tate](https://www.finalbuilder.com/forums/u/tate)\
**Post date:** [December 12, 2006, 1:26am UTC](https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261/2 "2006-12-12T01:26:45Z")

</div>

Hi Michael,  
  
I’m not sure if there’s a way to get SQL Server to run a restore automatically… it’s not supported by the sqlmaint.exe tool that does the backups. If you do know of a way to perform a restore, please let us know and we’ll look at getting that added as another action.  
  
cheers,  
tate.

---

<div class="post-metadata">

**Author:** ![dscheidt](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/d/e480ec/32.png) [@dscheidt](https://www.finalbuilder.com/forums/u/dscheidt)\
**Post date:** [December 13, 2006, 8:52am UTC](https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261/3 "2006-12-13T08:52:56Z")

</div>

Hi Tate,

One suggestion... Could you use the SQL commands to do backup and restore? We have developed database scripts that will do the work.

I'd \*love\* to see SQL Database restore added to the tasks available.

Thanks,

- David Scheidt

---

<div class="post-metadata">

**Author:** ![tate](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/t/e19b73/32.png) [@tate](https://www.finalbuilder.com/forums/u/tate)\
**Post date:** [December 14, 2006, 12:10pm UTC](https://www.finalbuilder.com/forums/t/sql-server-backup-and-restore/4261/4 "2006-12-14T12:10:11Z")

</div>

Hi David - yep, that’s one way to do it I suppose… will add it to the todo list.
