Yeah, I just finished it, added checks for the conncetion strings to make sure it can connect and if it cant to log what it cant connect to. I did...

I was able to store multiple values from my sql server table in the object variable, I'm currently storing: Connection String, Server Name, Server ID and Instance ID.

In reality the...

Ok how I've done this in the past.

Create a variable of type "Object" to store the ADO.NET connection string table

Create a variable of type "String" to store the individual...

• This reply was modified 4 years, 11 months ago by  oogibah. Reason: derp

The RESTORE statement looks OK, although I think I'd put an explicit NORECOVERY in the differential restore.  My opinion doesn't count, though - it's whether it works when you...

Okay, just FYI you may also run into some permissions issues if the service accounts for your dev environment (hopefully aren't) the same as the service accounts for your production...

What I did in this situation is I created a powershell script to grab the latest backup from the prod share and copy it to the location and then have...

If you're just looking for todays date you shouldn't need the dateadd(day,0,getdate()) at all you would just need the getdate()..

I've used the cast that I posted above in quite a...

• This reply was modified 4 years, 11 months ago by  oogibah.

That seems like a slick solution. ...

• This reply was modified 4 years, 11 months ago by  oogibah.

I'm a noob, but what if you casted them as date so it doesnt include the  time portion?

where CAST([TransactionDate]  AS DATE)=CAST(GETDATE() AS DATE)

• This reply was modified 4 years, 11 months ago by  oogibah.

I can't speak to #1 but I've worked with an AG  in my environment ( I just didn't set it up, but I have had to recover it )

#3/4 personally,...

Seems to me, that rather than giving them access to this proc, there should be a view created with what they supposedly need access to.

Absolutely: https://support.microsoft.com/en-us/help/4101502/tde-enabled-database-backup-with-compression-causes-corruption

One of the first reasons I came to this site is because I was experiencing a TON of corruption going on in my databases, literally every night,...

Unless you're using TDE then compression prior to 2016 can be bad. ( or so I've read, I don't care to tempt it myself )

I personally haven't seen it, and I don't know that the per cpu matters, but splitting the data files across multiple physical drives could act as a sort of makeshift...

Hey Jon,

I troll these forums looking at other peoples issues so I can have a better understanding when I run into issues of my own..  That being said I'm trying...