dso808 (8/11/2010)

---

Now we've been working on restoring the system databases first (of course) to the new instance and came up across this problem. Our production server has 2 drives...

Hello, me again.

God this guy Russel likes Dell doesn't he? Not on the payroll by any chance is he? 😀

Just one piece of advice, don't do it!!

If a machine starts...

Firstly, it would help if you post in the correct forum location for help with your issue, that aside the link at

http://support.microsoft.com/kb/918992/en-us

does not apply to your scenario in any...

you're welcome 😎

The following gets any SQL Server login that has had their account changed in the last 3 days

select [name] as SQL_User, modify_date as ModifiedDate

from sys.server_principals

where type = 'S' and...

you need to add that drive as a dependency to the SQL Server instance you wish to use it on. You will need to offline the service resource first, then...

which version\edition of the Windows operating systsem are you using?

you're welcome 😉

To be fair that does catch a few people out!

All username and password changes for the service accounts bound to SQL server services must be updated via SQL server configuration manager!

You are dowoading the wrong CU. You have selected x86 and not x64. Revisit the download page and select the correct CU. To see other downloads available click

Show hotfixes for...

The backslash is not an issue, open a sqlcmd window and try it.

My screenshot shows, you can enter a statement on line 1 and you push return expecting the...

the clustered sql server instance uses a virtual network name which is shared between nodes.

There should be no issue

you could use SMO calls or build from T-SQL scripts!

no, if enetering T-SQL statements into the SQLCMD console you need to signal the end of the batch using the GO statement.

The attached screenshot shows this!