I appreciate if some one provide some idea on this issue

thanks,

one more question:

Are the Security update patches & Cumulative Updates different? Is the cumulative update patch includes all security updates?

If I install this security update, will the SQL Server...

Thank you, I got it. But I want to know which one is the Best practice

1. Dynamic ports for all named instances

2. Set a static port for all named instance

Question:...

Thanks,

I went through the document and it says "Named instances of the Database Engine and SQL Server Compact 3.5 SP1 are configured for dynamic ports. This means they select an...

In Our production,...

Whose bright idea is it to disable the relational engine? SSRS runs on the relational engine so how do you plan to run updates without the relational engine?

There are a...

I have verified again that all databases are in Simple recovery mode and NO transaction log backup is scheduled. We are using Maintenance paln for full backup. Below is the...

Thank You,

There is an integral piece of information. Knowing that the server is clustered is essential information for the answer.

Using net stop net start for the services will cause the...

We stop the...

thank you,

Could you please advice me what is the best to way to start and stop the SQL services instead of starting one-by-one from SQL Server configuration manager manually.

I...

Hi Steve,

I would like to know what is the current version of SQL Server 2008, that can be used for Production?

Because we are planning to Upgrade our SQL Server...

Thanks Ian,

I'm able to bring the Secondary online by applying the tail backup of primary(Primary is in Revovery mode now) then again configured log shipping from Secondary to Primary. Its...

From the link http://msdn.microsoft.com/en-us/library/ms178117%28SQL.90%29.aspx

Changing Roles Between Primary and Secondary Servers

After you have failed over to a secondary server, you can configure your secondary database to act as a...

Role Switch is only possible when Primary Instance is available right?

please correct me if I misunderstood

thanks

Thanks Steve,

The issue is that you are calling your current server, the one you failed over to, the secondary. Once you failover, it's the primary. all log shipping starts from...