darkfour (10/14/2011)

The DB is too large to send from the remote site each week

What happens if you use SQL 2008 compression when taking the back up. Does that reduce the...

Regarding: To avoid this I would suggest you to go for differential backups. I backup / restore and you are done.

So the remote site sends me the original full backup...

I apologize for hijacking this post, but I think your technique could be used to fulfill a request I've received. My users want a copy of a remote database...

By SSIS I assume you mean SQL Server Integration Services? Yes, that is installed...I connected to it and I see two folders: Running Packages and Stored packages. But...

Are you sure there are service packs for SQL Server 2008 R2? I've been unable to find any. Please post a link if youhave one...thanks!

My mistake, the SQL version is 2005 but I specified in the server_sql_details table that it is a 2000. I changed the value from 8 to 9 and it...

Drew, I've added a bunch of servers and except for convert issue, it's going great....except for one server I'm getting this error when I run usp_getfailedjob:

Msg 207, Level 16, State...

I was able to create my web page! Thanks Drew!

Gary

Thanks Drew, I think I'll have to wait for your code change, as I can't change the users jobs on the servers. Please let me know when you've made...

That did the trick! Thanks! I've added additional servers to table Server_SQL_Details for a total of 10. I have one job in failed state on my named...

Hi Nick, I thought we tried that and it didn't work. I tried it again and now it works?! I must've been doing something wrong. Next question:...

Hi Drew, no we haven't got this working. We'll be adding more named instances to this server, so SCOME would really be a great tool to monitor them. ...

Thanks Drew, we're looking forward to the new articles.

Quick question: We have set up links to several servers that just have the default instance installed and it works great...however, how...

Great stuff so far. When will part 4 be posted?