| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2007-02-22 : 09:09:12
|
| Hi,Unfortunately our DB server has run low on HD space and we no longer have enough space to do a backup to the same server. I want to backup to a network path, but I am not having any luck.I mapped my network share as "F:", however its not coming up as an option when I try to backup with EM. When I type it in manually it errors out.Am I missing a step here?Thanks very much!mike123 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-22 : 09:18:19
|
I don't know whether you can do this in EM. You would probably need to use the UNC name, rather than the mapped drive - so instead ofF:\pathuse\\RemoteCompute\RemoteShare\path\...You may have to do this in SQL rather than EM.Note that the SQL Agent Service, which runs scheduled tasks, has its own login, and permissions etc., and you will need to make sure that the Windows User which the SQL Agent Service logs in as also has access to the Share etc.Can you get away with using a Compressed Folder for the backups instead? (I believe this is not recommended, but FWIW we have been doing it for years without any problems)We also do a FULL backup on Sunday and a DIFFERENTIAL backup Mon-Sat to reduce the disk space required for backups. Don't know if that will help you though!Personally I would install more disk space on the server than risk a cross-network backup which may fail for any number of connactivity reasons - increasing the risk that you have NO backups  Kristen |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2007-02-22 : 10:10:44
|
| Hi Kristen,Thanks for the suggestions., I will try your network suggestions and let you know how it goes!.I'm not sure if I can get away with a compressed folder, I have never used a compressed folder for anything so this idea is new to me but sounds interesting.My DB is 12 gb. I have 7gb free. My backup is approx 8gb, and I usually zip it down to about 2.8gb. I've removed everything off my drive and can't do a backup, so I am in a bit of a jam. I definately want to get more HD space, but I figure its going to take about a month for a new server. I was also looking at sqlbackup by redgate.Any further input is much appreciated.Thanks again!mike123 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-22 : 10:59:43
|
| "I have never used a compressed folder"Connect to the server. Right-click the Folder in Windows Explorer; choose Properties then Advanced (I think) and the Compressed option is on there.(There is a setting in Windows Explorer to show compressed folders in a different colour - probably a good idea to turn that on!)Make 100% sure that the folder ONLY contains SQL Backups. If you compress the actual MDF / LDF files that SQL Server is using it will choke big time!I would expect compressing a folder of SQL Backups to compress by 50%Dunno about sqlbackup from RedGate - but they have a good reputation. There is also LiteSpeed which does compressed backups.Kristen |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2007-02-22 : 12:46:03
|
| Hi Kristen,Thanks so much for the help. I did the compressed backups and I believe it probably compresses the file after its done writing as I could not complete the backup still. I'll look into LiteSpeed :)cheers,mike123 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-22 : 13:09:26
|
| "it probably compresses the file after its done writing"Hadn't thought of that; that might be the case.Any other folders [e.g. containing little used / archive files only] on that machine that you could "compress" to gain you some extra disk space?Kristen |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2007-02-22 : 16:35:31
|
| Unfortuantely, no. I'm really at the end of the wire here =[Perhaps the litespeed and other programs compress on the fly? Otherwise I think my only option is a network backup until I get my new drives.Thanks again! :)mike123 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-22 : 16:38:38
|
| Yes Litespeed compresses on the fly. It has saved us around 75% in disk space. That is huge savings ($$$$) for us.Tara Kizer |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-02-23 : 09:04:47
|
| Redgate SQLBackup also compresses on the fly. We have gone from 25G Backups to 3Gb . . . Big savings for us as well. Plus the ability to mirror the backup to another server across the network at the same time-- RegardsTony The DBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-24 : 04:55:29
|
| "Plus the ability to mirror the backup to another server across the network at the same time"Mmmmm ... that's nice.What sort of money are the RedGate and Litespeed products?ThanksKristen |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-02-26 : 07:51:51
|
| IIRC its 395 for a single server PRO edition licence, 3200 for a 10 Server licence, and we negotiated a 30 Server Licence for 5K-- RegardsTony The DBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-26 : 08:38:55
|
| Thanks Tony. |
|
|
|
|
backing up DB to network path (mapped drive)