Yes you can set up multiple publications and subscriptions....

Use Full text search catalog for that.

Basically you have chosen the option during the Loggshipping setup to restore the database in No Recovery Mode that is why it is showing you the status of Restoring... Look...

You cannot use this view as the password stored is in encrypted format.

Hi, You need to do the following in order to install the SQL Server 2005 default instance.

First you need to uninstall the SQL Server 2000 default instance.

Then install the...

I am not seeking any more suggestions on this. I have written my own script for this task and I am not seeking any help from you lot. Do not...

Thanks for your suggestions but this is not me who written the script this is written by some one else in the company and that is why its really complecated...

Dont need to be rude. I have fixed my script without any of your help. Any way I want tell you that this is the company requirement. I know how...

Gilla Monster, I dont know why you are trying to change the subject of my post. Actually what I requested is that " IF SOME ONE CAN LOOK AND FIX...

Yes we are taking the full backup of the databases before we run this job. So this is not the problem the problem with this script is its not working...

You need to do the following in order to enable the database mirroring on you server:

1: Open SQL Server Configuration Manager

2: Right-Click SQL Server serivice.

3: Click on Advanced tab.

4: On...

We need to run this as job montly after the month end. As I am working for big financial organization and this is the business requirement. I know what are...

You can either Remote Desktop the SQL Server machine OR Use SQL Authentication.

Guide lines to install any PATCH or SP is as follow.

Stop all SQL Server Services.

Install the SP or PATCHES.

Start the SQL Server Services.

You should not change your server name once the SQL Instance has been installed because in windows registery on some entries it still points to the old name. I think...