SqlServer-QA.net

Just got an email notification of a new whitepaper from the SQL Customer Advisory Team on Database Mirroring and Log Shipping Working Together. It covers: Converting a log shipping setup to a database mirroring partnership Setting up log shipping to a 3rd destination (i.e. warm standby to go with the mirroring hot standby) ...

One of the user has been confused to see lot of .TUF file within their server where the log shipping is enabled. Basically this .tuf file is the Transaction Undo File, which is created when performing log shipping to a server in Standby mode. So if you ask why standby mode, database recovery is done when the log is restored and this mode also ...

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group policies. Initial thought of the error brings up permissions issue while copying the file ...

This was the question asked by one of the user in the forums.  Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method of performing Log shipping between 2005 and 2000 instance will not be valid, as in case if ...

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then ensure to test them by restoring on to the standby server. This is a best practices than assuming ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition &  SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL ...

SQLmaster we have a requirement to provide high availability for 1 application that is used 24 hours 365 days with minimum time of maintenance for database checks etc. in this setup how can we keepup with high availability as we do not have any time availability for databases optimisation tasks. we are also looking to implment log shipping or ...

Suhas Welcome to the forum and congratulations being a first poster of SSQA forums! As you will be surprised that setting log shipping in Clustering environment is as normal as you setup in non-cluster environment, you want to use log shipping wizard as this will guide to setup LS successfully and take help of this Article to set it ...

Brad McGeehee is a SQL Server Industry expert and a founder of SSP website which is one of the popular websites in the Microsoft community. I feel great to be associated with Brad in bringing up the forums and website too.  He has a vast knowledge in setting up Cluster in SQL Server environment, refer to this Technet Webcast (on demand ...