.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SQL Server VSS Writer -Differential Backup - Does it even work?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 
I have been trying to develop a tool to do backup/restore of MS SQL Server using SQL Server VSS Writer. I can not get the differential backup working! I am just curious as to whether anyone ever made differential backup using VSS. Here is what I have been doing,
1. Create a full backup and store files and the Backup component document associated with it.
2. Update the tables in the database.
3. Create a new backup by setting 'SetBackupState' as VSS_BT_DIFFERENTIAL
4. Now when adding the existing components to the Backup Component Document, I find the component's time stamp from the document in step 1, and then invoke it with 'SetPreviousBackupStamp'
5. Now after the snapshot is taken, I go through each of the component and invoke 'GetPartialFileCount' API. This always return the value 0. I am assuming if there is a change in an existing component, it should give a value greater than 0.

Am I missing something here? Do we need to start SQL Server VSS Writer using certain parameters or something? I tried different configurations including (Windows Server 2008/ SQL Server 2008)



View Complete Post


More Related Resource Links

Windows Server Backup fails when SQL VSS Writer service is running

  

Hello. On one of our SQL servers, we have SQL Server 2008 Express installed. Whenever is the "SQL Server VSS Driver" service running, backing up the computer with Windows Server Backup will always fail. If I stop SQL VSS writer service, then it the backup will finish successfully, although apparently backup of the SQL DBs is not consistent.

Details:

- backup is executed with "wbadmin start backup -allcritical -backuptarget:d: -vssfull -quiet"

- root of the SQL Server instance (and all DBs, trans. logs etc) are located on a volume E:

- once the backup command is executed, it's stuck on the creating volume shadow copies operation for several minutes, failing afterwards

- SQL VSS Writer has status 8 (failed), last error is "non-retryable"

- eventlog contains myriad of messages since the backup is started (SQL server has hundreds of DBs on it), with variations of these 3 repeating:

  a) SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1304. Thread=15788. Server. Instance=SQLEXPRESS. VD=Global\{A4C1E365-459A-4D41-B3D0-1A76DB8E56F6}517_SQLVDIMemoryName_0. Source: SQLVDI, EventID: 1. This is repeated numerous times, where thread id varies and number (517 in this case) in the VD identifier

  b) BACKUP failed to complete the command BACKUP DATABASE

SQL Server Backup and Restore (video)

  
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.

AsyncPostBackTrigger doesn't work on server..

  

Hi, 
 I am new to asp.net and ajax. I have a problem while using update panel.
I have a tabcontainer with 3-4 tab panels. Inside one tab panel there is a cancel button. What i want to do is to when i hit cancel button in code behind i change active tab index to 0 so that tabcontainer shows first tab panel. I have update panel around tab container. This works at my localhost. But on server its behavior is very random. Sometimes it works sometime it doesn't. Unfortunately I am not able to debug it also. I don't know how to debug code on server. As on localhost it works correctly so I am kind of stuck. 

Any issues removing backup mount point cluster resources from SQL Server dependencies?

  
Win 2003, SQL 2005/SQL2008 64 bit enterprise failover cluster with 3 nodes and 6 instances. The mount points configured as cluster resources for the data/backup/logs. The entire cluster mount points are SAN replicated to a DR Site. But backup drives/LUNs are excluded from the replication. All the disk resources including backup LUNs are set to dependencies on the SQL Server server. The SQL Server is not coming on-line in the DR Site due to unavailability of the backup LUNs (failed resources). As per the documentation all the disk resources must be set to dependencies (http://support.microsoft.com/kb/835185). Thought it did not specifically mentions only Data/Log mount points and/or the backup LUNs as well. "The SQL Server 2005 resource depends on the SQL network name resource and the physical disk resources that hold its data. When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over. "     What if I remove the backup LUNs from dependencies list. This will allow me to recover the SQL Server

SQL Server backup failing on one file

  
Hi I have a server which is not backing up a db each day. When I look at the event log it displays the following...   SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\########\########_File_CS_DefaultData.ndf] in database [########] (5). The OS file handle is 0x000006A0. The offset of the latest long I/O is: 0x00000008e00000 2010-08-16 16:07:38.19 Backup Error: 3203, Severity: 16, State: 1. 2010-08-16 16:07:38.19 Backup Read on "D:\########\########_File_CS_DefaultData.ndf" failed: 1117(failed to retrieve text for this error. Reason: 15100) 2010-08-16 16:07:38.20 Backup Error: 3041, Severity: 16, State: 1. 2010-08-16 16:07:38.20 Backup BACKUP failed to complete the command BACKUP DATABASE ########. Check the backup application log for detailed messages. 2010-08-16 16:12:14.32 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\########\########_File_CS_DefaultData.ndf] in database [########] (5). The OS file handle is 0x000006A0. The offset of the latest long I/O is: 0x00000009900000 2010-08-16 16:13:07.02 Backup Error: 3203, Severity: 16, State: 1. 2010-08-16 16:13:07.02 Backup Read on "D:\########\########_File_CS_DefaultData.ndf" failed: 1117(failed to retrieve text for this error. Reason: 15105) 2010-

Sql Server 2005 backup misses files

  
I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

Server-side validation on an Entity Framework required field (property) does not work!

  
Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    

SQL Server VSS Writer "Status"

  
Hello, I have an HP Server running Win 2008 R2 Ent. X64 SP2 with Hyper-V and been having issues with Windows Server Backup. My original post can viewed here http://social.technet.microsoft.com/Forums/en-US/winserverhyperv/thread/6a20c2e9-499e-4ae3-9c21-f6a6971d9e5f/#676611f6-1d1f-4c1c-84f8-84f6bae9187b I have read a lot of forums and article and done windows update, but could not get the Windows Server Backup to work manually or on scheduled time. The above link shows the list of errors when the backup runs. When I opened the Service list I noticed that SQL Server VSS Writer had a status of "Starting" and startup type "Automatic". When I stopped the service I managed to get the backup to work manually and on it scheduled time. Should this service be stopped and set to automatic or should be started and automatic? Thanks..

Compatibility problem: an "sql server 2008 R2" db backup cannot be restored to an "sql server 2008"

  
To verify if the "2008 R2" version can be restored back to a "2008" dbserver I make an experiment:  construct a database on R2 version ( version : 10.50.xxx )  and backup it; then I try to restore the db backup to a "sql server 2008" db-server ( version : 10.0.xxx ) but get failed. Error message is as shown: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.   Originally I want to upgrade a "2008" server to "2008 r2" , but this problem withdraws me: if I do so , I am afraid all the existing clientuser's dbs cannot be backed up to themselves if they don't have "2008 r2" locally:   if a database is backed up under "2008 r2" environment whereas client user only has "2008" db server, does it mean he cannot restore it anymore?   So I wonder if there is an approach that helps me to create a "backward-compatible" database; when creating database on wizard there is an option to choose "compatibility level" but I don't think it meets my requirement..    Anyone can help me on this ??    

Can't restore database backup file in my database ? using sql server 2005. please help

  
VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

Backup SQL Server 2008 R2 Restore on SQL 2008

  
I have a SQL Server 2008 R2 instance that I need to backup and restore onto a SQL 2008 instance. When I attempt to restore the back up (.bak) database from the R2 SQL server onto the SQL 2008 server I get the following message: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo) How can i backup the SQL 2008 R2 database to be compatible with SQL 2008?Ian Ceicys

SQL Server and MapPoint: Making MapPoint 2010 and SQL Server Spatial Work Together

  
While SQL Server is a good repository for geospatial data, it doesn't communicate with MapPoint as well as it could. So our geo-data experts show you how to read point and polygon objects from SQL Server and render them in MapPoint and how to write points and polygons back to SQL Server using Entity Framework 4.0 included with Visual Studio 2010.Eric Frost, Richard MarsdenMSDN Magazine September 2010

Backup server

  
I have a 2008R2 server that does AD, sharepoint and file shares.  What I need to have to is if the main server goes offline a second server pick up where it left off. What is the a good solution for me?   Thanks

Remote Blob Storage - does SQL Server do all the work?

  
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t

Remote Blob Storage - does SQL Server do all the work?

  
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server

  
System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server 

Why doesn't SQL Server 2005 Enterprise always shrink a log file after a backup?

  
I have several databases that, despite being backed up regularly, do not release space to the operating system.  In one extreme case, I have a log file that is less than 1% utilized (and has been for months.) I know how to manually force a shrink, but I should not need to do that on any sort of regular basis.  In fact, it is against best practices to manually shrink a log file (or any database file for that matter) because of the very high risk of an unrecoverable error. It is my understanding that SQL Server will eventually handle these things on its own.  However, it does not appear to be doing so.  Any thoughts as to why? Thanks, Dave
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend