Snapshot Microsoft
Snapshot Microsoft
Why is Microsoft Volume Shadow Copy (VSS) so important to backup?
As time progresses, more and more backup applications (including ROBOBAK) are becoming Volume Shadow Copy (VSS) aware. VSS is a technology developed by Microsoft that allows a backup application to safely backup locked and open files. VSS works by creating a snapshot of the entire drive and then provides this information to the backup application so that the application can utilize the snapshot.
Volume Shadow Copy is supported on Windows XP, Windows Vista, Windows Server 2003/2008, Windows 7 and above. Both the backup application and software application must be VSS aware to utilize VSS to backup open and locked files. Legacy applications tend to NOT be VSS aware, forcing users to find other methods to backup those open and locked files. Other options to backup open and locked files include open file drivers and Pre/Post scripts to shut off/start an application before and after backup so that the data's integrity is guaranteed.
Some VSS Limitations:
- Only supported on Windows XP, Windows Vista, Windows Server 2003, Windows Server 2008, Windows 7 and above.
- Only local disks are supported.
- Windows XP only allows one shadow volume to be created per drive at any one time.
- The software program that created the open or locked files needs to support VSS.
- The Microsoft Volume Shadow Service must be enabled in the O/S.
- The machine must have devices that are enabled and associated with the Volume Shadow Service.
- The system must have an NTFS partition that must exist on an internal drive, with at least 100MB of free space for the shadow copies.
- The drive that contains locked files must have free space available.
- VSS can fail if there is too much disk activity.
Find out how ROBOBAK uses VSS by visiting http://www.robobak.com
About the Author
Ben Puzzuoli - ROBOBAK
Microsoft Word's Invisible Margins?
So... all of a sudden I get these random margin markings onto my Microsoft Word documents that didn't used to be there. To show you what I'm talking about: http://img84.imageshack.us/my.php?image=wordij1.png
I took a lil' snapshot of it. I've looked under all the options and tried to set it to default since it didn't used to be like this, no dice. Any ideas? That'd be helpful since I'm borderline OCD here and I've had to make white boxes to cover them up so I can write my papers and well, that is quite a hassle. So any help would be awesome.
Alas, text boundaries is already unchecked.
Thank you in advance.
Under tools>options>view, check to see if the text boundaries option is checked. If so, uncheck it. I think this should help.
Snapshot Microsoft
LHN Backup and Restore Microsoft SQL 2005 with VSS Snapshots
How To Configure Database Mirroring For Microsoft Sql 2005+ Standard+
Database mirroring allows you to set up a primary and secondary server which have the same database. The primary database is the only one you can use until you're faced with a disaster and the primary server cannot be used. In addition to the two 'partner servers' (principal and mirror) a database mirroring session may have an optional third server, called the witness. The witness server's role is to enable automatic failover. When database mirroring is used for high availability, if a principal server suddenly fails, if the mirror server has confirmation from the witness, it can automatically take on the role of principal and make its database available within a few seconds.
Some important items to note about database mirroring:
· The principal database must be in the FULL recovery model.
· The mirror database must be initialized from a restore of the principal database with NORECOVERY, followed by restores in sequence of principal transaction log backups.
· The mirror database must have the same name as the principal database.
· Because the mirror database is in a recovering state, it cannot be accessed directly.
If you don't want to use High Availability you can control fail over to DR via a High Protection operating mode. High Protection Operating mode is a Synchronous Transfer manual fail over which does not require a witness server and has FULL transaction safety.
Database Snapshots and the Mirror Database
As the mirror database is in a recovering state, it is not accessible and not readable. With SQL Server 200x Enterprise Edition and Developer Edition, you can create database snapshots to read the mirror database at a point in time. Database snapshots provide a read-only view of a database, exposing data that is consistent at the point of the snapshot creation. Note that you CANNOT create a snapshot if the primary server is unavailable so it is not a valid DR or DR Test method.
Steps for installation
Prereq: SQL Server service must be set to run as the domain account that has permissions to control the mirror.
1. Backup Primary Database (FULL and then TRANSACTION LOG)
2. Restore Primary Database to the Mirror Server WITH NORECOVERY (same locations must exist)
3. Wait for the Mirror database to revert to the status In Recovery
4. On the primary server right click the database Tasks > Mirror
5. Click Configure Security
6. For auto failover, you will need to specify a 3rd server as a witness. Manual failover is recommended.
7. Select the Primary server, Mirror server (you'll need to connect) Just keep the defaults.
8. Type in the domain accounts that have rights to both servers
9. Start Mirroring
10. If you get a 1418 error you need to ensure that port 5022 is available from both servers and also that you performed your backup/restore properly (ie: did an additional backup on top of the full that appended the transaction logs)
11. Note that the mirror will always be in a (Mirror, Synchronized / Restoring...) state because the mirror is effectively constantly 'restoring' production changes to DR as they occur. You cannot use this database at DR for a DR test until you mount a point in time.
Using your database Mirror
Now that you have an active synchronised database mirror you might want to use it in a DR test. If you only want a read only copy you can create a database snapshot. To create a snapshot run this query (red text is variable based on what you want to call your snapshot, where you want to put it and also what your database name is. Note that snapshots can only be created in Enterprise (or developer) editions of SQL Server
CREATE DATABASE SnapshotName ON
( NAME = N'ImportantDatabase', FILENAME = N'C:YourSnapshotDirectorySnapshotImportantDatabase.snap')
AS SNAPSHOT OF ImportantDatabase
Note: Manual failover can be initiated only from the principal server (which is stupid for a DR situation where Prod DB Server dies)
Note: The database must be online to have a database snapshot (which is stupid for a DR situation where Prod DB Server dies)
Bringing up the DR Mirror
From the DR Database mirror server you need to run this query
ALTER DATABASE ImportantDatabase SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
This will set the ImportantDatabase at DR to be the Principal and you will be able to point your application servers to this database. WAIT for this mirror to have the status (Principal, Disconnected) before pointing your DR apps to it
Do your DR tests and now you have a choice. What of the 2 primary SQL servers is the master? Were changes made in production during the DR test?
Option 1: Make the DR SQL Server the Primary after the DR Test or Real DR
If you re-establish the link to your production database Mirroring will be suspended. You can right click > Tasks > Mirroring > Resume to mirror the changes that were made at DR back to production. There is a screenshot of the choice you are given by SQL here: View Mirror Resume SQL Message. If you choose to resume mirroring you can quickly change the primary back to the production server by clicking FAILOVER in the same mirror configuration screen.
Option 2: Destroy Changes to DR SQL Server, Re-Mirror the Production server to DR
If the changes made at DR aren't needed anymore you can right click > Tasks > Mirroring > Remove Mirroring on both the DR and Prod SQL servers. This will leave you with two non-mirrored databases with the same name on each server. You should take a backup of the production database and restore it over the top of the DR database using the same methods discussed at the beginning of this article (the norecovery full and logs backups).
For more information please visit http://technet.microsoft.com/en-us/library/cc917680.aspx
About the Author
This article was written by Tim Roadley, creator of the new website www.askearn.com where you can get paid to solve peoples problems, or pay to present them 
|
|
Fujitsu ScanSnap S510 Sheet-fed Scanner $1,199.00 SCANSNAP S510 18PPM 600DPI USB2.0... |
|
|
Creative Labs USB Webcam NX $25.00 The Creative Labs PD1110 Webcam is just the thing for videoconferencing, instant messaging and video email. Simply attach it to your USB-enabled PC via integrated 6-foot cable, and away you go! Great looking images are yours to capture, with no focusing or other adjustment required. No need to crack open the computer's shell. No card to install. Simple!... |
|
|
Kensington VideoCAM Digital PC Camera (PC and Mac) $9.59 USB Camera with 6 ft cable VideoCAMworks software on CD-ROM Users guide Quick start guide Microsoft NetMeeting for PC White Pine Software's CU-See Me video conferencing for Mac... |
|
|
QuickBooks Pro 2012 $127.39 QuickBooks Pro 2012 lets you organize your business finances all in one place so you can quickly find the information that you need. Easily create invoices and track your sales and expenses - and get reliable records at tax time. QuickBooks Pro 2012 can be set up in minutes and is easy to learn and use. Save time and get organized with the tools of QuickBooks Pro that make your everyday business t... |
|
|
VMware Fusion 4 $39.00 Switch to a Mac and Run Windows Programs Without Rebooting VMware Fusion 4 has been refined from the inside-out to give users the easiest, fastest and most reliable experience in running Windows applications on a Mac without rebooting. With over 90 new features including OS X Lion optimization, an even more Mac-like design and next-generation 64-bit performance, VMware Fusion 4 is the best way to... |
|
|
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin $30.30 Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copiesDelivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) processDelineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, tra... |
|
|
Pro SQL Server 2005 Replication (Definitive Guide) $89.99 Replication is a way of copying and updating information in a database. This allows all users to see the same information and any changes made to it. Replication also duplicates the database across a number of computers so that, if one computer goes down, the information is not lost and can still be accessed. Pro SQL Server 2005 Replication, written by Sujoy Paul, a Microsoft Certified Professiona... |
|
|
A Guide to SQL Server 2000 Transactional and Snapshot Replication Having more power and features than any other enterprise RDBMS, Microsoft® SQL Server® Replication has been lacking a clear, consice guide to installing, configuring, and troubleshooting for its users. Finally there is a complete and authoritative reference book that addresses these issues, guiding the reader to use SQL Server replication to its full potential. In more than one thousand pages, M... |
|
|
Spore Creature Creator $9.99 This is not the game. It lets you create characters for the game. Game is expected to be released at a later date.... |
|
|
Virtual Resort: Spring Break $0.99 The more fun they have the more fun you have!Product InformationIt's time to slather on the suntan lotion slip on your flip-flops and headdown to the beach for an epic spring break party! From the feverish flingsto sloshed scuffles to savage shark attacks with Virtual Spring Break you willexperience all the pleasure and pain of running your very own vacation hot spot.As the Spring Break king... |
Snapshot Microsoft
