If it's a default installation then you should find the SQL Server error log under E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log

Has the account that the SQL Server Service runs under been given the necessary permissions on the 'new' E: drive?

Regards

Lempster

stormsentinelcammy (2/21/2014)

---

Luis Cazares (2/21/2014)

---

You're welcome.

Do you understand how and why it works?

I also missed the link in my previous post. Here it is: How to Make Scalar UDFs Run Faster...

Lempster (2/21/2014)

---

So you want to change the scope of a variable from one package to an entirely different package; is that correct? If so, I don't think this can be...

Personally I think a Full backup every 2 hours is overkill and like Grant said, it does put load on the system so your users may find their application(s) less...

So you want to change the scope of a variable from one package to an entirely different package; is that correct? If so, I don't think this can be done...

Not sure. You...

If you use a Tally table the query is simply:

SELECTDATEADD(dd,-1,DATEADD(mm,DATEDIFF(m,0,GETDATE())+N,0))

FROMdbo.Tally

You can create and populate your Tally table using this code (taken from Jeff Moden's article about Tally tables [/url]which is...

You might get more answers if you post in the Reporting Services forum. I think you can ask the Forum Moderators to move posts.....

Well, it doesn't make sense to have a Full backup schedule that is more frequent than your Diff backup shcedule so I can see how that caused problems. I would...

Your starting point should be to look at the Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for each database/system. The first means "how quickly should we be able...

Does it need to be red and flowery or green and stripy?

By 'pretty much' I meant because mirroring involves the transaction log, but you are right Perry, I should have been more specific. The link that I provided should give the...

Yes, but ideally you would have both instances at the same service pack level.

Regards

Lempster

I agree with Jeff, but would put Step 10 as Step1; that way when things go wrong it won't seem so bad! 😀

Regards

Lempster