Thank you for the response.

So no worries about screwing anything up because I am doing the testing on sample databases located on my local machine (lmacdonald), over two different instances....

Hi.

We will be setting up transaction log shipping for about 20 databases and having them all in one job sounds like a good idea. There where some parts that...

That is correct, -1 0 or 1 depending on the previous value compared to the current one. It is working correctly, I just am not processing why I'm getting...

Something I found to be interesting. The backup works if I uncheck ignore databases with the state is not online. However these are the principal db's at the...

Yep, just says it completed...

xp_cmdshell 'net use z: /delete'

GO

xp_cmdshell 'net use z: \\winvtblacka02\dbateam /USER:dbateam dbateam'

GO

Is the code before the backup begins, I don't use a SP. You are correct, it only backs...

Sorry could not attach a picture.

Hey Guys,

I have been trying to figure this out to. The link in this thread sets a policy that determines free space in the .mdf file. I don't...

Yep, Thanks!

Bids 2008 is the version. I am looking at that link now, this information is all new to me so it will certainly be challenging to implement.

Yes they do resume. The network guys say they don't see any bad packets coming through the switch interfaces.

It turns out there was a mix of logs and database files on the drive which is why some databases responded differently then the others. Two days ago we...

Hi,

So a domain admin gave the account permissions to dynamically modify spn's with read and write. This fixed an issue we were having where people could not log in...

Thanks I'll check out the package )

I never written scripts before and I need to copy all these MSDB Packages to a folder on the C: drive. I need something that can populate the SAMPLEPACKAGENAME...