Scheduling backups of a remote SQL Server 2005 database to a local file without using Management Stu

microsoft.public.sqlserver.tools

21 Nov 2006 8:30 AM

Debbie Croft

I'd like to find a tool that will automatically (at set periods) back up a
remote database to a (local) file on my desktop computer - and restore it,
if necessary, obviously.

I can't install any new software on the server. I don't want to install SQL
Server just to do this. I'd like a smaller dedicated (and cheaper)
application that just does this.

Is there anything like that out there?

21 Nov 2006 12:45 PM

Dejan Sarka

> I'd like to find a tool that will automatically (at set periods) back up a
> remote database to a (local) file on my desktop computer - and restore it,
> if necessary, obviously.
>
> I can't install any new software on the server. I don't want to install
> SQL Server just to do this. I'd like a smaller dedicated (and cheaper)
> application that just does this.
>
> Is there anything like that out there?

In Windows, you have a scheduling service - check Scheduled Tasks. You can
execute a T-SQL script for the backup using Oslq.exe (SQL 2000) or
SqlCmd.exe (SQL 2005).

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/