.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

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

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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? :)

Do I need free space when doing full database restore in SQL Server 2005?


I have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.

The restore fails. Is it because a full restore needs  free disk space of 60G in this case?


"sqlrun_sql.msi" needed to complete Visual Studio 2005 SQL server installation


I had a hard drive failure at work so had to reinstall my whole development environment :(

I installed Windows 7 Professional.

I installed Visual Studio 2005 full install.

It suggested I installed Service Packs for the components to make them compatitible with Windows 7.

Windows update attempted to install "Security Update for SQL Server 2005 Service Pack 3" which always fails.

I looked at the help that came with the failure error and it said to got to "Control Panel -> Programs and Features -> Visual Studio 2005 SQL Server -> Change" then finish up the suspended installation.

I do this and the installation asks for "sqlrun_sql.msi" which I cannot find on any installation disc or anywhere on the internet.

I have tried to repair Visual Studio 2005 and that didn't help.

Will reinstalling Visual Studio 2005 help.

This is so annoying as everytime I shutdown, windows trys to install the VS SQL update and it fails.

Any ideas?




SQL Server 2005 Full Recovery


Hi All,
How do I do full recovery of database in SQL Server 2005.
I have full backup at 5 PM
and log till 6.45 PM. Now how do I recover my database. Could any one provide the scripts for backing up using roll forward.




Log file is growing in secondary server (MSSQL 2005 log shipping)



logshiping is configured in our enviroment between SQL2005 SP3 Enterprise edition , we made the online secondary server for testing perpose. now again we have restored the latest full backup (size was 1000gb) into secondary server for maintaining the logshipping with norecovery mode . everything was fine and both databases is also in sync mode. but i have shrink the log file into promary server and database size reduced to 700Gb then automated backup happened and same backup is restored into secondry srever but secondry server log file size is still showing 350GB.

plz help us how to reduce the log flle of secondry srever, current status is

Primary server DB size is 750gb (50gb log)

secondary srever Db size 1050gb (350gb log)


Log Shipping and Full Backups

Do I need to stop/disable the Log Shipping Jobs on Source/Desitnation instances when I create full or incremental backups?  Or can these jobs just continue on their schedule while the full backup or incremental backup is running?  My customer is using SQL Server 2005 Standard edition and is using log shipping to a warm standby server. 

Will full or differential backup break LSN chain if compatibility level = 80 in SQL Server 2005/2008

My understanding is that full or differential backup will not break LSN chain starting in SQL Server 2005.  However, I'm not sure whether this applies to databases with compatibility level 80 in SQL Server 2005/2008 or not.

How to check why restore job of log shipping has failed in SQL Server 2005?

I'm suspecting that the restore job of log shipping has failed in SQL Server 2005 because the LSN chain is broken.  How can I verify my suspicion?

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

How to save Unicode in SQL Server 2005

I am using google transliteration to display the text in Hindi/Tamil

I tried to store the text appear as Hindi from textarea in an nvarchar
field of database (SQL Server 2005) , the text saved as "???????".

After retireving text from the same it display the text as "???????".

Can anyone help me how to store and retrieve the actual data from SQL
Server 2005?

I am using ASP.net,VB.Net and SQL Server 2005

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


need help: HTMLEditor, Sql-Server 2005 and CrystalReport


Hi All,
i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? how to do?


SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier


Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

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