|
In the backup config panels, Windows Server Backup warns that with backup to a network share, the previous backups are overwritten. What I haven't figured out is whether a failed backup results in NO backup, or if the failed backup is just dropped, leaving...
Started by Jason on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
You could try creating a .vhd file in your share location, attach it in disk management, then tell Windows Server Backup to use that as if it were a locally.
Failed Backup results in NO backup.
|
|
I have a production database where I run full DB backups every Sunday at 2AM and log backups every night at 3AM. The weekly full backups are around 100MB, while the log backups are around 1MB. But the log backup running immediately after the full backup...
Started by Aa on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Are you truncating or shrinking the log after the full backup....
One thing to check wouldbe if the wildcard/path of the log backup is picking up some archives, or if the large backup is generating enormous log files for some reason...
|
|
I have a backup task already set up with simple-backup-config (Administrative > Backup Config - I think, because I'm using pt_BR loc and just translated my menus). It backups my home and some other folders to a different drive (just for backups), and...
Started by Igoru on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
The current should overwrite your....
Sample crontab/ with something like ~/Ubuntu/$(date)/ to show the date of each backup as opposed to overwriting your last.
If the simple-backup-config does not allow multiple jobs, you can give cron a try.
|
Ask your Facebook Friends
|
On some of my SQL2000 servers, I have occasional blocking and weird conflicts between our full backup and log backup jobs. Based on The answers to this SF question , I need to figure out how to prevent my log file backups from running while my full backups...
Started by BradC on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
On the rare occasion when all the ....
The last step in the full backup job, successful or not, was to turn the log backup job back on.
backup was to run *sp_update_job* on the log backup job with @enable=0 to disable the job.
|
|
I have three maintenance plans set up to run on an Sql Server 2005 instance:
Weekly database optimisations followed by a full backup Daily differential backup Hourly transaction log backups The hourly log backups are usually between a few hundred Kb and...
Started by Dave on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at serverfault):
Your final question was: *"Other than BACKUP LOG WITH TRUNCATE_ONLY, is there any way to reduce the size of....
You could script but possible solution.
Of backup compression and/or fast backups, you can run full backups daily.
|
|
I have a Backup DB task setup to do a full backup of All User Databases. However, I find that when new databases are added, they do not get automatically included in the backup plan.
I am forced to open the plan each time a new database is added and select...
Started by Raj on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Any and 2008 - Backup, Integrity Check and Index Optimization.
Catalogs and add / remove databases to the backup plan and run that procedure on a schedule.
|
|
On our SQL servers (2000, 2005, and 2008), we run full backups once a day in the evening, and transaction log backups every 2 hrs. We haven't really worried about these two processes conflicting, but lately we've run into some of the following issues:...
Started by BradC on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
The large log backup is probably happening because of database maintenance operations which happen between the last log backup and the full backup the sysprocesses table (or DMV....
Database backups should normally be serialized.
|
|
...at least I think so.
I recently revamped my backup routine on my development server. I created a maintenance plan for user databases that did some weekly cleanup tasks, daily full backups and transactionlog backups at key points throughout the day....
Started by CJM on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
After you create a new DB until the full backup....
Then, that night (or whenever), it will do the full backup.
If you the one DB failed.
Don't worry about it too much.
To be a full backup to use as a starting point for rolling forward.
|
|
Hello,
I am looking at setting up a backup solution... well including in my backup solution actually... an external harddrive on my main file server. I then use something like Microsoft SyncToy to 'sync' data onto the external hard drive.
I currently ...
Started by TravisPUK on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
You should have....
Yes it will help if all your drives die in the main server, but if someone deletes system to your backup.
I do have a backup domain controller but do not currently know how to configure file replication useful backup.
|
|
I have:
1 Linux "backup" server (Ubuntu 9.10 server) (plenty of disk, new server) 2 Gentoo servers 2 CentOS servers 3 Windows 2003 servers I'd like to backup all of the servers as disk-to-disk backups to the Ubuntu backup server.
HOW?
Please be gentle...
Started by TheCleaner on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
A simple and effective tool I've used the clients can't delete or change the actual backup files..
, ...), then you can simply backup them as diskfiles.
|
