If you are looking for automatic failover than you should think about clustering or mirroring option.

Refer following link for further detail:

http://msdn.microsoft.com/en-us/library/bb510414.aspx

HTH

Refer the following link for realted replicated table:

http://msdn.microsoft.com/en-us/library/ms179855.aspx

The link include other than Transaction replication object too; you need to segrigate as per your need.

HTH

We are using "Latin1_General_CI_AI" 🙂

I guess you need to re-configure the mail as it's unable to find the mail server details.

MSDB contains all the informations regarding jobs, history, mail, maintenance plans, Scheduling etc.

Hence...

Hello Shane,

Refer the following link for performing the failover.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/edfe5d59-4287-49c1-96c9-dd56212027bc.htm

HTH

Nick,

You need to create the user first.

Refer this link for further detail:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/61a40eb4-573f-460c-9164-bd1bbfaf8b25.htm

Cheers!

Hi Shane,

Yes you have evaluated almost all the possibilities.

Here Cluster is an very ideal solution for your scenario.

And yes you can do detach and reattach the database but looks not...

If you do have 'sa' privilages you can check following:

1. In surface area configuration xp_cmdshell is enabled.

2. exec this command in Query window

sp_helpuser 'PostOptApp'

If about command gives...

humm... can you check the database if it's rebuilded; as /qn suppress all error messages and setup dilogbox.

Check the logfile too.

Also if possible (NOT PRODUCTION) try changing collation setting with...

Give full path for setup.exe e.g. c:\sql\setup.exe or D:\Servers\Setup.exe

Are you kidding? somebody will say delete something and as a DBA you will do it? (It's good and save you as you didn't took any action)

Always refer BOL if...

Hello Chris,

Check this in regedit

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\MSSQLLicenseInfo\MSSQL9.00

if Mode value is 0 and ConcurrentLimit 10 than client lincenses is for 10.

Usually Log file is 20-25% of your datafile. But still it depends on the application you are running, frequency of T-log backup, using logspace at the time of maintenance etc.

HTH

You can try again restore.

Be careful if it's production.

Full proof plan for rolback MUST having upto date backup of all system as well as user database.