Thank you all for your appreciations...

I'll try to write more useful articles like this...

Thanks again...

Jay.

Since it is an Active/Passive cluster, you can Install the SP3 on the Active node (where SQL running on), so cluster will take care of the installation on both nodes.

After...

Even I too if he needs only to update the changes on the target, but if he wants to keep the secondary database online for the users then he can't,...

sihaab (8/13/2009)

---

I want to create a new database at secondary server and restore the production database at the secondary with only PRIMARY file group. Now, users can access this database...

unless you keep the database in standby or norecoverymode, you can not apply the diff or trn backups on top of it.

Still you can do that thru logshipping, only...

I added another table on the user filegroup as below and took another Trn backup and restored on the target database with standby option and tried to do a SELECT...

Based on your question & as per my understanding I tested in my testinstance. Its worked.

I did the following, check if you expected the one.

Created a test database with PRIMARY...

Write your question clearly and easy to understandable, then only the forum members can help you to resolve the issue.

Do you want to copy a file inside SQL using...

I hope PSEXEC is known tool to everybody, anyway PSEXEC is a tool which helps execute processes romotely.

Eg. if I wants to start/stop a service in a remote server from...

The common scenarios as follow

In the windows cluster environment, generally C and D drives will be local where SQL dictionaries will be copied while installation. The system and user databases...

You can try like this...

DECLARE @SQL NVARCHAR(1000)

DECLARE @DBNAME VARCHAR(40)

SELECT @DBNAME = 'MSDB'

SELECT @SQL = 'EXEC'

SELECT @SQL = @SQL + ' '+@DBNAME +'..sp_helpfile'

EXEC SP_EXECUTESQL @SQL

Check this link.

http://www.mssqltips.com/tip.asp?tip=1180

Are the SQL instances running on domain account? Please ensure the principal and mirrored instances running on domain account.

Thanks for your useful tips.

Thanks Rudy.

As per you, my understanding is below, pls correct if anything wrong.

Which means after changing the SQL services pwd in Active node the new pwd will be replicated to...