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. Ca
n 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 the
se
> 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. Ca
n 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 the
se
> 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 us
ing T-SQL commands.
Link the remote instances to your central server.
Create DTS packages on your central server to run the stored procedures on t
he remote instances and then FTP their
resulting backup files to some other server.