BACKUP DATABASE

Question

BACKUP DATABASE

Lester Policarpio

SSCertifiable

Points: 7109
More actions
January 6, 2008 at 8:19 pm

#70687

Can i backup databases and saved i directly to another server?? for example:
BACKUP DATABASE TO DISK = '\\LESTER\LESTER$'
Is this possible? or is there any way that i can do this thing? thanks..
"-=Still Learning=-"
Lester Policarpio

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

You can do this, but it's not recommended. Any network hiccup will result in this failing. Better to back up to a local drive and then copy to a remote drive, use a VBScript or Powershell script to do this.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

I agree with steve . You can also backup to a tape. Its better to backup to a local drive and copy to a remote location.

"Keep Trying"

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 3

Thanks for the quick replies just thought of making a script that do all the jobs like:

1. backup databases from a server to another server

2. restore databases

3. Create server/database user/log-ins

4. Create backup schedules

but since there are issues regarding this matter maybe i'll just do it the old way ^^

"-=Still Learning=-"

Lester Policarpio

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

There are lots of scripts here on the site in the Scripts section that do these things. You can search a few out and modify them to suit your needs.

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 5

Actually i made 1 script that will do what i need it is just that the backup to another server is my issue but anyways i can manually do the backup part 🙂

"-=Still Learning=-"

Lester Policarpio

Paul Mu SSCertifiable Points: 5547 More actions · Answer 6

Or else migrate to 2005 and use the mirrored backup option. Read up more in 'Introduction to SQL Server 2005 Database Backups' in SSC.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Be careful of mirrored backups. If the mirror fails for some reason (network errors), the local isn't completed.