you could do a data compare. there are various tools available to accomplish this. Visual Studio for Database Pros and redgate sqldata compare are the 2 I have used, and...

I'm not advocating this as a permanent solution, but rather a step to narrow things down. is it possible to give the account you are using in the server agent...

You are using the configuration manager to set this up right? you are not doing it direcly in services, I know that can cause security issues if you do it...

BTW - did you go to high school in Michigan?

I used to know a guy named Eric Goforth

I'm sure you probably did this, but can you double check to make sure you are using the correct password for the agent service. Just paste it in there again.

I play guitar and bass. We also have a high number of musicians in our department. not so much on the server/admin side as the programming side. This also hold...

look at these tables in msdb:

backupfile,

backupfilegroup

backupmediafamily

backupmediaset

backupset

you could certainly have both instances running on the physical box if it can handle both, but the previous suggestion isn't bad either.

I prefer to create my databases using the SA login. That way we don't run into problems with logins getting deleted. This works well for our environment. We are also...

OK, so you have a couple of options here. If you think one node can handle both intsances, there should not be a prolem. you would end up with an...

Fist, ensure SQLMail is enabled using the sql server surface area configuration tool.

Next, be sure you have an outlook client installed and working on the server.

Log into the server...

So I take it you have a two node active/passive setup, having one instance installed on a two node cluster?

we get that error sometimes. In our environment, it's usually caused by deleting the login that owns the database. We then have to change the owner to SA using t-sql...

yeah, I realize the cap on the sizes, but it's frustrating to me that I can't actually set it to unlimited growth. I'm trying to setup monitoring for consistent settings...

here it is, you will need to rename it to .tdf