MS SQL Server Tools - Re: Scheduling backups of a remote SQL Server 2005 database to a local file without using Managemen

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Scheduling backups of a remote SQL Server 2005 database to a local file without using Managemen

Dejan Sarka

2006-11-21, 7:14 pm

> 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/

Sponsored Links