|
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.
|
|
Here is what I am doing,
Take full FILE backup at 1.00 AM Take differential FILE backup every 15 minutes And we ftp all data to other location and restore everything there So now from My Source database to Destination database, every 15 minutes, its replicated...
Started by Akash Kava on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
This....
The big difference in your case they did at 8:00 AM .
Differential backups backup everything since the last full backup; log backups backup everything since the last log backup.
backups incorrectly.
|
Ask your Facebook Friends
|
...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 ....
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.
|
|
I am not proficient in the use of Symantec Backup Exec, I will like to know what is the best known backup strategies for a simple file server. I have 5 LTO 3 cartriges new and available to start this strategy but don't know what will be the best approach...
Started by Geo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
I just skimmed it on my ....
In 11d, select Backup-->New Policy Using Wizard.
In Backup Exec rotation for you to the backup device of your choice.
A pretty easy-looking way to set up BE is to use the Policy wizard .
You're at it.
|
|
I have a SQL 2005 SP 2 server running a maintenance plan that performs full backups every day at 22:00, diff backups every 4 hours and log backups every 30 minutes. The plan backs up all system & user databases (all user DBs are in Full recovery mode)...
Started by Chris W on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Also check the duration of the full backup job, there....
I think that you should check out the job history for the job that executes the full backup at 22 database for which there's no full backup have no full backup scheduled.
|
|
I'm thinking about signing up for an online backup service, like Carbonite . Both of these keep entire revision histories of your files, not just the latest copies.
So my question: if I want to switch services, or cancel entirely, do any allow you to ...
Answer Snippets (Read the full thread at superuser):
Try it for yourself:
Double-click the Carbonite Backup Drive icon is likely to take at most a....
Connection speed:
How much stuff can I back up?
There are no limits on backup storage capacity from your backup with just a few clicks.
|
|
Recently, one of the main file servers at our company failed. It was using a 4 disk RAID array, but apparently 3 of the disks died, and all the data on the server has been lost.
Speaking to the sys admin, he says that he has been warning the upper management...
Started by Rick on
, 14 posts
by 14 people.
Answer Snippets (Read the full thread at serverfault):
Edit: yes I concede the fact any backup is more reliable than the backup was in place....
The company is clearly looking for a scape goat in this, the sys admin is quite right not to backup the top" solution doesn't look so expensive.
|
|
I have never imaged a hard drive, so I don't know what software to use or how to prepare my system for imaging. Is this the best way to backup? In the past, I've always just kept a copy of my important files on an external drive and in Gmail or DropBox...
Started by NoCatharsis on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at superuser):
If you simply backup important files, when your do an image backup, all ....
Imaging a hard drive makes a sector to the state it was in when you did the backup.
Create an "important file" backup depends entirely on your needs.
|
|
07-29-2011, 09:44 AM Why you should backup
Hard drives die. Computers are lost or stolen. Water damage. Accidental deletion a file or program. Power surge fries your electronics. Natural disasters. System restores and clean installs.
Those are just a ...
Started by schweb on
, 15 posts
by 8 people.
Answer Snippets (Read the full thread at mac-forums):
Mark No ....
Mark You can encrypt the TM backup disk you'll lose your previous TM backups.
Are backing up to a Time Capsule wirelessly?
Thanks.
|
