congrats, Jeff.

in case we have misunderstood your question the transaction log backup job could be created by setting up a maintenance plan via SSMS

when setting up the alert via sqlagent (right click on alerts), log filling (by percentage) is one of the default options I believe. You can then tell it to respond...

I go down the pub.

At this point you'd be better off installing 2008R2.

agreed. Any changes to database users made on the primary...

as this looks like a windows login and therefore should not have been orphaned by restoring on a different server I can only presume the database backup did not contain...

you have to pay for it unless you have purchased software assurance.

cheers

ok,cheers Perry

look into the 'with move' clause of the restore database command

if you are using the gui you can specify where to restore the database files to on the options tab

when you run it first thing it does is self extract then the GUI opens. Then you just follow the prompts.

Hi Perry, only one presently, we are going to build a second server and add it to the windows cluster, then I will install SQL.

I think there is a DBCC command that can handle this situation. 🙂

unless you have software assurance you cannot do that. you have to buy a license as if it was a new install.