Yet another quick one for you. One of my colleagues was trying to set up a job to run a DTS package (yeap, I know, a bit of a last century stuff). Whenever he ran the package from the command line, everything was running fine. However, when he ran the same package from within a … Continue reading DTS package runs from command line, but fails from SQL Server Agent
Month: July 2011
How can I tell if my restore process is actually doing something
Just stumbled into this: if you have a large DB to be restored, it might take forever to actually see the progress moving to 10%, 20%, and so on. Yeah, I know, you should never do a restore from the SSMS, but don't try to tell me thatJ. Anyway, coming back to our scenario: if … Continue reading How can I tell if my restore process is actually doing something
SQL Server 2008 cluster installation – IP address already in use
A quick one today, but I intend to make a series out of it, especially that we're having loads of "fun" with clustering: we encountered something in the line: IP Address 192.168.1.100 is already in use. To continue, specify a different IP address". Okay, I think this one filled the glass of my colleague, but … Continue reading SQL Server 2008 cluster installation – IP address already in use
SQL-PLAY 