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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Standalone utility to verify backups

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server

does Microsoft provide any stand alone utility which can verify a backup file for consistency?

I have plenty of backups being copied over to a network server. the network share does not have SQL installed. But I want to verify the backup copies.

View Complete Post

More Related Resource Links

Automate Monthly Restore To Verify Backups


Please help me with details on

1.how i can automate a job to go ahead and restore a specific database from one server to another every month so that i can be sure that the backups are valid.

2.Once done, I would like to run checks on it. Please provide a list of database validation checks that should be performed. Is a basic health check sufficient???

3.Send myself and email and drop the restored db. 

Thanks in advance!

Utility Spotlight: 12 Steps To Faster Web Pages With Visual Round Trip Analyzer


Download Visual Round-trip Analyzer (VRTA) to uncover the root of your Web page loading problems and identify these 12 common ailments.

Jim Pierson

MSDN Magazine November 2008

The type 'DataGrid' was not found. Verify that you are not missing an assembly reference and that

Hi; I'm new to WPF and I was going through the ExpenseIt tutorial on MSDN's website. The tutorial was working fine until I added DataGrid. I got the error message: "The type 'DataGrid' was not found. Verify that you are not missing an assembly reference and that all referenced assemblies have been built."     I could not find a clear answer online of which assembly references to fix and how to fix them. Any help would be appreciated. Thanks!     Note: I'm running the following: Windows Vista 32-bit operating system Microsoft Visual Studio 2008 Version 9.0.30729.1 SP Microsoft .NET Framework Version 3.5 SP1

DataContractSerializer do not verify "xml markup name" / "property name" correspondance

Hello, I use the DataContractSerializer o serialize / deserialize a complex class. During deserialisation, if an XML markup does not correspond to any property of my class, or if a property of the class is not present in the XML, there is not a single warning. This is problematic if a user make an invalid modification in the xml, or if a developer make a refactor in the code... How can I change this behavior ?   Thanks for your time.

Can I safely perform full backups without breaking log shipping? Can I do point in time restores if

I'm building a system using SQL Server 2008. I have log shipping set up across our WAN, and that's working fine. I need to perform local backups on the primary server so that I'm not relying on the (slow) WAN if it needs to be recovered from a server crash. Ideally, it would be nice to be able to perform point in time restores. I understand that I can use the transaction log backups, created for log shipping, to restore from. But I still need a full backup to start the restore from - and there seems to be some confusion regarding whether or not performing a regular full backup on the primary server will affect log shipping. Even on these forums, conflicting advice has been given, with some people saying it's fine as long as you don't do transaction log backups, and others saying you must run COPY ONLY backups (though they were talking about Server 2005). From what I understand, you can't do point in time if you use copy-only backups. I'm getting the impression that this used to be a problem under 2005, but under 2008 you can safely perform full backups while log shipping is running. Can anyone confirm my understanding before I make a career-altering error? :)

SQL Server 2005 Log Shipping and subsequent FULL backups that are needed

Afternoon,   I have a few Log Shipped DBs that are working great.   Currently they are set to fire off every 15 minutes 24/7.   My question is this ... I need to get FULL backups of the source DBs in order to restore them on certain Dev boxes.   If I were to execute the full backup on one of these Log Shipped DBs ... how would it affect the log shipping process?   Is there a special method to accomplish this?   As a side note, what would be some concerns/issues if in being able to create the FULL backups and not interupt log shipping, I were to create the backup using a 3rd party tool like Quest LiteSpeed?   I sure wish we were on Enterprise, then I could create a mirror and then snapshot off it to create my backups BUT ... that is not the case as we stand today.   Thanks

What type of backups create a LSN No.?

What type of backups create a LSN No.?"SQLSERVER DBA" "INDIA"

The report server is not responding. Verify that the report server is running and can be accessed fr

When I trying to configure Reposrting services in IIS & XP. It hsows me error  "The report server is not responding. Verify that the report server is running and can be accessed from this computer."   I also configure with reposrting configuration tools which show all confuguration is perfect.   but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx   or http://localhost/Reportserver   It shows error. I try all ways still not works ..Help me out   Thanks.

Cost for SP2010 Enterprise for standalone developement?

I need to set up a SP developement environment.  It will be a standalone system and not used for test or production. I want to install SP 2010 enterprise for this but will need it longer than the 180 day eval period.  My question is - Does this install, in this environment, require licensing i.e. cost money?  We have the enterprise installed and licensed but I want a separate dev install. Any ideas on where to go to get this information? I can't find it anywhere that I am looking.

The type 'DropShadowEffect' was not found. Verify that you are not missing an assembly reference a

We created a grid in Expressions Blend but the DropShadowEffect caused an error for a developer who tried to build the solution and did not have Expressions Blend on his machine.  Had to replace with  <Border.BitmapEffect><DropShadowBitMapEffect ... Are there other incompatibilities between Expressions Blend and plain old Visual Studio 2008 development environs? <   UserControl   xmlns=http://schemas.microsoft.com/winfx/2006/xaml/presentation   xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml   xmlns:d=http://schemas.microsoft.com/expression/blend/2008   xmlns:mc=http://schemas.openxmlformats.org/markup-compatibility/2006   mc:Ignorable="d"   xmlns:igRibbon=http://infragistics.com/Ribbon   x:Class="TestEditor.Ctrl_PR"   x:Name="UserControl"   MaxWidth="450"   d:DesignWidth="450" d:DesignHeight="125">     <Grid x:Name="LayoutRoot" RenderTransformOrigin="0.5,0.5" Width="450" Height="125">   <Border CornerRadius="8" BorderBrush="DarkSlateBlue" BorderThickness="0.5" HorizontalAlignment="Stretch" Grid.ColumnSpan="2">     <Border.Background>       <LinearGradientB

Running website in standalone PC

Is there possible for me to use the website I developed using Microsoft Visual Studio for standalone PC??? Or it's a MUST to upload it into the server then only can be used??? 

How to Create SSIS Package to RUN the preweblog utility exe for IIS Logfiles

Hello ,                   I need to create SSIS Package for Microsoft tool  preweblog utility.exe to modify the IIS LogFiles. Kindly provide me some information related to it.

Security Context Token verification failed. (The security protocol cannot verify the incoming messag

Hello, I would like implement Message Lever security with username/password authentication on HTTP. My environment looks something like this.  Server Side - Message lever security is configured on service.           <security mode="Message">             <message clientCredentialType="UserName" negotiateServiceCredential="True"/>           </security> - CA and self signed certificates are created on server and configured. ServiceCredentials are looks like this <serviceCredentials> <serviceCertificate findValue="CertForIdm" storeLocation="LocalMachine" storeName="My" x509FindType="FindByIssuerName" /> <userNameAuthentication userNamePasswordValidationMode="MembershipProvider" membershipProviderName="IfMembershipProvider" /> </serviceCredentials> Client Side (References are generated by VS) - Binding configuration                 <binding name="WSHttpBinding_IWaypoint2" closeTimeout="00:11:00"                     openTimeout="00:11:00" receiveTimeout="00:10:00" sendTimeout="00:11:00"  &nb
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