Have you seen Tom thomsons new avatar?

Looks like the operation was a success.

Of course soon as he changes it (again) this post will look stupid.

😀

no, you are not going up versions of SQL (e.g. sql2000 to sql2008)

you could backup\restore or detach\attach the databases to a standard edition install of SQL, or a google search bought this up:

http://sqlblog.com/blogs/tibor_karaszi/archive/2011/01/27/upgrading-from-express-edition-to-standard-edition.aspx

see

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

keep enough backups so that if the copy jobs fail the logs are still on the primary to be copied without breaking the log chain. In most cases this means...

duplictae post.

replies here please

you're late Perry 🙂

A /passive option is interesting, when did that become available from? what I wonder (without doing lots of research) is whether MS have deemed to make it...

to add to the level of information out there on geo-clusters this is what I did (applying a security patch)

Two node cluster, nodes A and B, node A active

In failover...

thanks. worth being aware of I thought.

try restarting SQL on the secondary

Hey, I've made a difference! (finally)

http://connect.microsoft.com/SQLServer/feedback/details/342832/active-active-logshipping-restores-clear-proccache

joe-1142036 (11/18/2011)

---

I'm getting permission denied to exec that. Would that be a bad security exposure for a hosting company to provide that service account name to a customer? ...

presuming you have access to SSMS try this:

declare @account varchar(50)

print 'MSSQLServer service account '

exec xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\Services\MSSQLServer', 'Objectname', @account output

print @account

...failing that, ask them 🙂

I would tend to keep SQL away from the OS. If space is an issue and the C drive has a lot of spare capacity put your backups on it.

If...

the error you are getting is actually saying the path does not exist rather than it does not have permissions to it (that would be error 5).

however, the SQL service...