How do I automatically backup my sql server 2005 express database on another server?

[Nada Adel]

I can't seem to find any way to backup my database on another server every hour or so. Is there a way to do that? I'm using sql server 2005 express edition.

[Abhishek Sur]

Why dont you use Windows Service to create backups. Generally Backup doesnt take network paths. so it is better to do this in your own server in a specific folder and a service will move the file from the place to where you want. :)

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Johan Hakkesteegt]

You can even do what abishek said, with a simple batch file, and a scheduled task.

My advice is free, and you may get what you paid for.