Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
backup of 2 different SQL Server Options · View
Previous Topic · Next Topic
oursgris
#1 Posted : Wednesday, April 07, 2010 4:30:09 AM Quote
Rank: Newbie

Groups: Registered

Joined: 4/7/2010
Posts: 2
Hello
I'd like to know if the following case are supported by one copy of sql backup and ftp standard :
- backup of the databases located on two different instance on the same computer
- backup of the databases of 2 SQL Server located on 2 different server

If possible, how ?

Moreover, is it possible to remotely backup SQL Server 2000 on a computer located on the same local network ?
Same question for Sql server 2005 ?

Regards
Back to top
 Report Abusive | Report SPAM
alex
#2 Posted : Wednesday, April 07, 2010 10:31:30 AM Quote
Rank: Administration

Groups: Registered

Joined: 8/10/2009
Posts: 143
oursgris wrote:
backup of the databases located on two different instance on the same computer

- You can create two jobs to use one job with one instance.

oursgris wrote:
backup of the databases of 2 SQL Server located on 2 different server

- The best solution is to have a separate installation on each server.

oursgris wrote:
Moreover, is it possible to remotely backup SQL Server 2000 on a computer located on the same local network?
Same question for Sql server 2005 ?

- Remote backup on SQL Server 2000 is not supported, but you can install the application on the server with SQL Server 2000 to backup database using standard way. Regarding SQL Server 2005, you can use remote backup but I suggest you the previous scheme because remote database backup is in beta.
Back to top
WWW  Report Abusive | Report SPAM
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.