Backuping up Remote Databases

Hello,
I have one SQL Server on a server. and 3 other (?MSDE?)SQL Databases on
pc's in the plant. I make daily backups on the server of the databases.
The SQL databases on the pc's(I'll call clients) don't run sql agent. Can I
back up these databases from my central server. Each of the clients
are(should be) setup alike. So, with my job I would need to maybe zip these
files into a file so I know which machine it came from. For example after I
backup the master, msdb,and user DB, zip into a file called, pc1, pc2, pc3.
Any suggestions?
Thanks,
BrianThat would require some programming. I'd look into the DMO programming API (SMO if you are on 2005).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Brian Shafer" <BrianShafer@.discussions.microsoft.com> wrote in message
news:72F32CDD-C790-4B2C-AE45-7AF2D5083BB7@.microsoft.com...
> Hello,
> I have one SQL Server on a server. and 3 other (?MSDE?)SQL Databases on
> pc's in the plant. I make daily backups on the server of the databases.
> The SQL databases on the pc's(I'll call clients) don't run sql agent. Can I
> back up these databases from my central server. Each of the clients
> are(should be) setup alike. So, with my job I would need to maybe zip these
> files into a file so I know which machine it came from. For example after I
> backup the master, msdb,and user DB, zip into a file called, pc1, pc2, pc3.
> Any suggestions?
> Thanks,
> Brian|||Brian Shafer wrote:
> Hello,
> I have one SQL Server on a server. and 3 other (?MSDE?)SQL Databases on
> pc's in the plant. I make daily backups on the server of the databases.
> The SQL databases on the pc's(I'll call clients) don't run sql agent. Can I
> back up these databases from my central server. Each of the clients
> are(should be) setup alike. So, with my job I would need to maybe zip these
> files into a file so I know which machine it came from. For example after I
> backup the master, msdb,and user DB, zip into a file called, pc1, pc2, pc3.
> Any suggestions?
> Thanks,
> Brian
You could try something like this:
Create a stored procedure on each remote instance to backup the databases using T-SQL commands.
Link the remote instances to your central server.
Create DTS packages on your central server to run the stored procedures on the remote instances and then FTP their
resulting backup files to some other server.