Can we failover to a lower version of SQL Server?

Currently mirroring is configure on two servers

Principle SQL Server 2008 R2 SP3 (10.50.6220)

Mirrored SQL Server 2008 R2 SP3 (10.50.6000)

Will we have...

Thank you, the link worked for me.

Sorry I was not able to reply earlier. I have a different way that you can try. Let me know if this works for you.

Step...

Cool deal.

The way I figure is that the STIG is asking us to determine if there have been any changes to or additions to stored procedures, functions and...

I had this problem on a SQL Server 2012 stand alone.

I fixed it by giving the account that runs the agent service permissions to the folder E:\Program Files...

Sorry I posted twice

Below is how I resolved these STIG Checks. I go by STIG ID number so please make sure these are the ones you are asking about. Let me...

I have a document ready, but need to clean it up before posting it. Is there a particular STIG you are having trouble with that i may be able...

Thank you very much for the help.

I figured out a way to test on both dev or production:

I will restore a database from an existing database and call it TEST_DB. I will also create a...

Thank you very much for the response.

These are the answers to your questions.

what login owns the maintenance plan job(s) that failed: My windows account in SQL...

Thank you very much for the information. I will look into it.

Great questions.

the STIG is the Security Technical Implementation Guide and its created by a DoD Agency called DISA (Defense Information Systems Agency). The guide is a checklist of...

Thank you very much for the reply. I may have resolve the problem by doing the following:

Step one: Create a job to execute daily called DB-STIG and use the

Following...

I was just wondering if anybody had any idea of what could be done with this STIG Check.

Any help would be appreciated.