See the below attachment.

You should be able to see this.

If you want to change from T-sql, check BOL for exact syantx....

@suresh,

Thanks for reply.

i have framed following queries :

select @@SERVERNAME as Server_Name,publisher_db,publication,

publication_type, description from dbo.MSpublications

select * from dbo.MSsubscriptions

where subscriber_id > 0

But still not comprehensive, i think

Nice.. Short and Sweet.

to have backup files compressed in log shipping, i think you need to install that particular 3rd party tool on both the servers ( primary & secondary - on Primary...

Since SQL 2008 has come up with inbuilt backup comprassion then why should we look for 3rd party tool.

Also, i believe that 3rd party backup comprassion will not be practically...

Hi,

i can think of issue with file path or permission.

try to have backup at some other path and check if that is getting successfull or not?

@mike-2 --

Really a Nice article.

Firstly, you can use sp_who2 to find out what are the processess are runnng and which are causing deadlock.

@Bhuvnesh.

First thing u need to do is set Max Memory for each instance. That will restrict the instances to grab more memory then they deserve ( restart each...

Hi,

We are following policy not to install any software in the Operating System drive (which is generally C:\ drive).

Also for SQL Server, we placed datafiles / log files / backup...

Be it Active - Active or Active - Passive, Failing over of the sql instance will depend upon the possible owner.

Whichever node is selected in Possible owner section, instance can...

@Sushant,

Ideally Shirnking is not recommanded since it can cause fragementation.

And shirnking on Tempdb, i will not go for this operation unless i am in dire need of HDD space.

Hi,

First of all, which RAM you want to check.

1. Which is available at OS Level

2. Which is available at database Level.

If nothing is configured, then Both the RAM will be...

Just for Curosity :-D:-D

R u able to login on all the 5 instances....

( i think that u will not.. and all the instances will not be a complete installation.

Andy has replied correctly.

Try to have vendor work on their application and make it compatiable to SQL 2008 Directly.