If you just go by SSMS saying synchronized on both servers, then please make sure you hit refresh to verify they really are synchronized.

I like to check in the server...

We have one primary and one secondary in the HA cluster, and do the full and tran log backups on the secondary, but did the shrinks on the primary, because...

On which server are you doing the tran log backups and the full backups- primary or replica?

I had issues on sql server 2012 until I ran the backups on the...

The sql server is SP1.

I'm going to install SP2 in dev, and then the latest, CU7, and then put it in prod after everyone tests for some time.

Thanks again, Kevin.

Thanks very much for the reply.

I wasn't the one to set it up, but will check if there are any windows or sql server patches that need to be installed.

Thanks for the reply.

Glad the reporting services aren't an issue, since some people here use them.

Does anyone know about my other questions, about whether the SP2 hot fix includes all...

Thanks very much for the reply.

That's one less thing to worry about 🙂

Will wait to hear information about the rest of my questions.

Thanks very much for the fast response.

I was afraid of that.

The vendor applications to be moved to this server aren't certified for sql server 2012 or sql server 2014, or...

Hi, Sreekanth.

Yes, the backup I said worked was the tran log backup job.

Thanks for your help, and for verifying I didn't forget to turn on the tran log backups after...

Thanks very much, Sreekanth.

I was told by the SAs that they were doing Arcserve backups on the DB, but after you replied, I checked further, and found they were only...

Hi, Sreekanth.

It's set to LOG_BACKUP.

Thanks for the suggestion, but I had already granted insert to public, which is why all the logins can login but the one with special character in the name(possibly due...

Hi, Ed. I tried Common Criteria at first, but the vendor for the product we've bought doesn't support CC yet.

Thanks very much, George. It worked.

Thanks, George.

I'll monitor the size of msdb, and see how it's growing, and see how much space it will be with 10 days' history, and reduce the number of days...