The OS version will not affect these database replication techniques.

can I then recommend that you check logins still have the correct...

backup\restore with move is another possibility but alter database is the best way to do this.

If at all possible backup the database first, just in case.

this is a 'feature' (bug) of the install gui. Either accept the defaults (no harm in doing that) or install from the command line specifying the values you want for...

A christmas present for you............

http://www.sqlservercentral.com/articles/Administration/64582/

You need to be able to get inside Steves mind for these questions!

Remember, 7 points should not be too easy to get, and steve has an wicked streak! 🙂

Happy christmas!

was torn between reindeer and turkey, but knowing that americans eat turkey at thanksgiving guessed right.

so what do americans traditionanlly eat at christmas?

You can take the bits that you need out of here

http://www.sqlservercentral.com/scripts/Permissions/76450/

pls starrt a new thread so we don't hijack this one

I wouldn't say its a common practice, but the logical name is not really that important except perhaps for clarity within sys.master_files and making restores more straight forward.

I would guess...

reggie burns-317942 (12/16/2011)

---

Hi all,

I'm having the same issue, but I'm experiencing the issue with these dbs having the same logical name. I'm attempting to configure log shipping for over 100...

Its a change at the SQL level, which is a 'virtual' instance sitting on both nodes, so yes it will be in effect whichever node is the active node

edit: by...

as john said. Offline just stops the resource (and dependant resources).

Failing over is a different option (move resource).

Failing over would also cause a restart of SQL and start up the...

it will not force a restart.

with a cluster you have to use the failover cluster manager to restart SQL.

Right click on the SQL server resource and choose 'offline the resource'....

no probs