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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2007-11-15 : 11:50:23
|
| I am using sql server 2000 and windows server 2003 standard edition:My database backup job is failing due to lack of disk space. I am taking the backup onto E drive and the available free space on E drive is 6.85 GB and there are no other drives I can use for the database backups.The size of mdf file is 21 GB and that of ldf file is 4.2 GB.The transaction log back up of that db ran fine. This database recovery model is Full and Auto shrink is not checked.There is one primary filegroup for the database.In this situation, I am thinking of the following option:1. Backup the db and log files onto another network shared drive.If I want to still use the same server E drive to backup the db and log files instead of using another network shared drives.how can I do that. Please let me know the best way of handling this issue.Any help is greatly appreciated. Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-15 : 12:01:18
|
| To backup to a network shared drive, you'll need to provide the UNC path to it. If you ever expand the E drive, then you can simply switch the path back to a local drive.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-15 : 12:05:57
|
| So currently with my situation, backing up to a network shared drive is the only option I have until I add more space to the E drive? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-15 : 12:11:59
|
| Umm yes since you stated that you don't have enough free disk space on your E drive to put a 21GB database on it.You could of course purchase a third party product such as SQL Litespeed to get 75+% smaller backup files. That's what we do for our larger databases. It saves us a ton of disk space and also backup times are faster.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-15 : 12:32:35
|
| Thanks a million, for the speedy response. You are the best. |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-15 : 12:58:22
|
| >To backup to a network shared drive, you'll need to provide the UNC path to itAnd your SQL server should not work under 'Local System Account' |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-15 : 13:11:02
|
| I just checked the sql services acct, it was local system acct, I shall use the domain acct for the sql services. Thanks to everyone for the responses. |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-11-16 : 07:15:04
|
| Just make sure that teh Domain Account you use for the SQL Agent account is NOT a domain Admin one, following the principle of least privilege-- RegardsTony The DBA |
|
|
|
|
|
|
SQL database backup issue