Viewing 14 posts - 16 through 29 (of 29 total)
Ten Centuries, I had left out the fact that we also make on-disk backups of all system databases and user databases, and those BAK and TRN files are recovered by...
March 13, 2009 at 5:06 pm
Oops! Big typo. I meant to write "You can't start SQL server withOUT the master files being in place."
March 13, 2009 at 5:00 pm
Ten Centuries, the REBUILD option specifies that you need to reapply all updates. When I tried to reapply SS2005 SP2, it refused to install because there was a newer...
March 13, 2009 at 4:59 pm
[p]SS Champion, you can't start SQL Server with the master files, so most of that posting did not apply to this situation. As suggested in one message, I have...
March 13, 2009 at 4:50 pm
[p]Thanks for the quick feedback. especially the tip about using RESTORE HEADERONLY on the master database!
[/p][p]
I do backup the system databases and recovery them as part of the SQL...
March 13, 2009 at 4:18 pm
[p]Thanks for the quick response. That's Microsoft for you!
[/p][p]
My requirement is to call a VBScript (via the CScript host) to do some things as part of a...
March 13, 2009 at 4:09 pm
Ol'SureHand,
You probably have Cumulative Update 2 or higher on top of SP2. Prior to that update, the SSMS maintenance cleanup task - and the corresponding undocumented stored...
February 9, 2009 at 2:19 pm
CmdShell is a huge security hole. Does anyone have an SSIS package or a .Net source code for a DLL that could be called to do this without enabling...
February 6, 2009 at 12:33 pm
The maintenance task calls the same SP, so that is why the SP call makes no difference. The bug that prevents the delete from working is fixed in a...
February 5, 2009 at 9:43 am
I don't think you understood my question . Here it is again:
How can I detect the 4xxx error message in the "catch" portion of TSQL script when an in-line...
May 6, 2008 at 1:03 pm
Oops! The example showed the wrong error (one I want to re-riase), but it still illustrates the question ... how can I detect what was behind the 3013 error?
May 5, 2008 at 5:20 pm
Can you tell me how to handle this situation. There are two errors listed when the log backups is too old:
Msg 4305, Level 16, State 1, Procedure uspRestoreLogs, Line...
May 5, 2008 at 5:17 pm
I can't find a SQL Server 2000 resource kit for download. Here is the MS site of SQL Server 2000 downloads:
http://msdn2.microsoft.com/en-us/sqlserver/bb671138.aspx
Here is a search for the resource...
April 25, 2008 at 2:48 pm
That did the trick. Thanks!
Being a TSQL rookie, I had not yet learned of Try...Catch, but having done a little C#, I should have thought to look for that....
April 25, 2008 at 10:51 am
Viewing 14 posts - 16 through 29 (of 29 total)