Hi Steve,

Its clustered resource drive. we have installed Active/Passive clustered sql server 2005 EE 64 bit on windows 2003 64 bit recently. We have a sql group, which has D...

Hi,

Even my log shipping tables have some data after completely removing log shipping and all backup, copy & restore jobs from all databases.

Now, I have reconfigured the log shipping for...

Go through this link http://www.sqlskills.com/BLOGS/PAUL/category/Sharepoint.aspx

which says you can not create multiple filegroups for share point databases but you can create multiples files in a single filegroup.

I'm also looking for the same...how can we encrypt the password in web.config file

Thank You very much,

This information helped me a lot. I went through this link http://www.microsoft.com/Sqlserver/2005/en/us/reporting-services-features.aspx, and I found that Reporting Services Standard edition covers almost all feature that we have...

Could you please advice me how to cleanup the Log shipping tables, if disable log shipping task for database not removes everything?

Hi Max wei,

I have been disabled the log shipping for all the databases including the problem creating database MyDb. But some of the log shipping tables still have the...

Thanks you,

Executing below script on Primary has resolved the issue.:-)

DELETE FROM msdb.dbo.log_shipping_monitor_secondary

WHERE secondary_database='YOUR UNWANTED DBNAME'

Commands executed on PRIMARY:

1.

select * FROM msdb.dbo.log_shipping_monitor_secondary

Result:

Secondary_Server Secondary_Database

SQL2\ins1 ...

Yes, I went through the link and checked for all possible reasons for Troubleshooting Error Message 14421

But In my case, I had disabled the Log shipping configuration for the...

We have 5 instances on one node1 and 2 instance on 2nd node and 3rd node is passive for both nodes 1 & 2.

We have a backup group on node1...

Is there any workaround to get rid of this false alert error??

The alert job on primary server gives false alert because of the following .

We configured log shipping for a database and scripted that configuration using generate script option on the...

Hi anam,

Do you have created Backup group separately(which consists a backup drive) in cluster administrator or included the backup drive also in SQL group?

From BOL....

Create a file share for the transaction log backups, preferably on a fault-tolerant server that is not part of the log shipping configuration. To maximize availability of the primary...