Yes, Failing over to the Secondary server and then failback to the original server is possible in Log-Shipping. Please see this helpful video on how to do it . This...

As far as I know, you cannot start these services on a failover cluster's passive node. Try it for yourself. The system just won't let you start the services. I...

We had done pretty much similar thing on our environment. We did a in-place upgrade from SQL 2005 to SQL 2008R2. We did had some road bumps when it automatically...

Hi Anoop,

The Full Database backup taken on 28th is sufficient enough and have all the transaction changes till the 28th. You can apply the 28th full backup and all the...

Hi,

It is better to have multiple subscribers rather than setting up daisy chain setup.

Hi,

If you don't have a clustered environment I would not worry a lot since the patch/service pack installation will rollback if there is any issues. If it is a clustered...

Hi,

Good question. But are you trying to implement Log shipping only or SQL Fail-over Clustering as well on these systems. This article really helped me and my company when it...

I have used Idera Diagnostic Manager for a log time now. I really like their dashboard where you have a one shot view of all the metrics that you would...

Hi,

I change the Database Recovery Model to [Bulk Logged Mode] before I run by REBUILD INDEX job . After the RE-Index is done the database is put back to [Full...

I agree with that. While restoring the transaction logs to the secondary server, the users will be disconnected from the secondary database. Although it is a good practice to setup...

FYI

http://www.sqlservercentral.com/Forums/Topic1413261-1549-1.aspx

Hi again,

Recently I found two of the databases (Primary and Secondary) on my log shipping were Out Of Sync.

Below are the steps I performed to bring it back to...

Hi,

There are several ways to do it. I use our Redgate SQL Compare to see the data between primary and secondary are identical or not. RedGate SQL Compare is a...

Sotn,

It would be nice to inform the users of the Secondary Log shipping Database to expect a latency of around 1 hours (even though you have setup 30 mins of...

I'm using this script

IF EXISTS(SELECT * FROM sys.all_objects ao WHERE ao.name LIKE 'tbl_rebuild%')

DROP TABLE tbl_rebuild

CREATE TABLE tbl_rebuild (

schemaname varchar(100)

,tablename VARCHAR(100)

,indexname VARCHAR(100)

,fragmentation FLOAT

,page_count INT)

GO

INSERT INTO dbo.tbl_rebuild( Schemaname,tablename,Indexname,fragmentation,page_count)

SELECT s.name,o.name,i.name,ddips.avg_fragmentation_in_percent,ddips.page_count...