Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2006-10-04 : 07:30:28
|
| just wondering can this be done as i am going through enterprise manager and when i try to backup to disk it only shows me drives on the server i am working on |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 08:10:40
|
| I think you can do it with BACKUP command, not with EM.Peter LarssonHelsingborg, Sweden |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 08:24:31
|
| It is generally better to backup to a local disk and then copy the backup file to the remote location - this can all be scheduled of course!What you should avoid is a backup direct to a remote location which will fail if the network is down etc. If you backup locally first at least you will have the possibility of the local copy if the network is down!Kristen |
|
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-10-04 : 08:36:48
|
| its just we ahve a problem with space at the moment on the local server thats why we were going to put all backups on another one |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 08:41:36
|
| Yup, I suspected it might be something like that.I think I would still go down the route I suggested. Do you have room for one full backup of your biggest database?If so I would do:Backup databaseCopy to remote locationCheck arrived at remote location (i.e. some sort of DIR test)Delete local copyRepeat for next databaseWe have our Database Backups folder set to Compressed. I believe this is not recommended, but FWIW we've been doing it for years without any problem.There is also a commercial product called something like Litespeed which produces faster backups which are much smaller in size.KristenKristen |
|
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-10-04 : 08:59:04
|
| nope we ahve run out of room for any back up we are trying to delete some stuff of it but in the mean time i thought this would be the best option, not sure what to do |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 09:07:59
|
| Maybe you can shrink some databases and/or log files?That often frees up some gigabytes.Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Backing up to another server