Solved

Will SBS 2008 Standard backup files in use?

Posted on 2011-03-15
7
443 Views
Last Modified: 2012-05-11
I've been searching the net and must have missed something.  I was wondering if the new sbs backup software that differs from ntbackup.exe will backup files in use.  I do not remember what the term is that allows files that are in use to be backed up like will happen when using Symantec Backup Exec.

Thanks!
0
Comment
Question by:rexxnet
7 Comments
 
LVL 8

Expert Comment

by:Acosta Technology Services
ID: 35137418
Yes, it can backup using volume shadow copy (as long as nothing else is utilizing it) which allows it to backup files which are in use.
0
 

Author Comment

by:rexxnet
ID: 35137560
When would it be in use (I'm assuming you're talking about volume shadow copy)?  Let's say there's a data file that everyone writes to real time.  That's what my concern is.  If they are connected to that database, will the sbs backup backup that file?
0
 
LVL 8

Expert Comment

by:Acosta Technology Services
ID: 35137591
If you don't have Volume Shadow Copies enabled on the share drives then you should be safe.  Try running a small test backup job on a single file that you have open and check out the results, everything should work correctly.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 166 total points
ID: 35137656
SBS backup will copy open files with no issues - don't confuse volume shadow copy of shared folders with the volume shado copy service that is used to back-up open files - they are not the same thing
0
 
LVL 8

Accepted Solution

by:
Acosta Technology Services earned 167 total points
ID: 35137674
They are not the same thing, but it's also not recommended to have backup jobs overlap with volume shadow copies of shared folders.
0
 

Author Comment

by:rexxnet
ID: 35137842
Ok.  So, bottom line is that if I do not enable shadow copy on the shared folder with the database file, I should be fine?
0
 
LVL 57

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 167 total points
ID: 35142651
I would not go so far as to say you will be "fine." VSS has several "writers" that make sure things are in a consistent state. Yes, there is a default writer to back up open files and this works quite well. But with databases, especially ones that multiple uesers are accessing, OTHER problems can arise. Here is an example:

When exchange processes an email, it writes the email to the database store *and* it records information about that information in a log file. That is *TWO* files. Lets say you run a backup and the "snapshot" of files happens to occur *after* Exchange wrote the message to its store but *before* it wrote this information in the log file.

If you were to restore this backup, the *files* were backed up properly even though they were open. But *EXCHANGE* will detect a message in its store that it has no log entry for and will not mount the database store. This essentially makes the backup useless.

So...MS added a special "writer" to VSS that when a backup is run, all data is flushed to ensure Exchange is in a consistent state. SQL Server has its own special writer as well. Any database that has multi-user access probably will have a similar requirement, and no backup solution...MS's VSS, or BackupExec, can get around this. You will have to refer to the applicatoin documentation on what they recommend for performing backuyps. If they say that all users must be logged out to perform a backup then no "open file" solution can sidestep that requirement. If they provide a VSS writer then this becomes a non-issue (BackupExec now uses VSS as well, just as a by the way)....so you really have to refer back to the vendor before you can be sure you have a working backup.

-Cliff
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question