Viewing 15 posts - 1,201 through 1,215 (of 1,583 total)
"Thought" about it dropping/recreating the subscriptions...but having the guts to actually do it during the day - No.
This is a production OLTP system) so basically praying to make it to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 10:42 am
I see where you're going and yes I am able to back up the most recent backup of the distribution database to another server - CHECKDB returns no errors,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 9:45 am
Did you ever get an answer to this?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2012 at 2:42 pm
After attempting to run the CHECKDB I got this:
Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2012 at 8:44 am
I had run it a couple days ago and it had completed ok...
"CHECKDB for database 'distribution' finished without errors on 2012-02-15 21:08:54.840 (local time). This is an informational message only;...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2012 at 8:34 am
To update this toublesome distribution DB, the differential backup that ran this morning also failed:
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.4064
Report was generated on "MYSERVER".
Maintenance Plan: MAINT - Distribution
Duration: 00:06:07
Status:...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 20, 2012 at 8:02 am
Use a script task (just to see if that works) something like:
Public Sub Main()
Try
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 16, 2012 at 2:32 pm
This should have probably been posted under the Integration Services forum...
Can you attach your dtsx package to the post (excluding the FTP IP/username/password info of course)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 16, 2012 at 2:06 pm
🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 16, 2012 at 10:20 am
Can't you use parameter tables, a WHILE loop, and a TRY..CATCH block to accomplish this? Perhaps a couple tables like @Records (for the main data to be loaded into)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 15, 2012 at 9:54 am
I am quite familiar with that solution, but don't believe it allows for what I am trying to do specifically
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 15, 2012 at 9:37 am
To the best of my knowledge there is no way to "add" tables/objects to the linked server scripts as this is all controlled by access level under the security tab....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2012 at 2:21 pm
I agree with Jared, sounds like the way to go
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2012 at 9:01 am
Is this a local drive or a networked backup location? Seems risky to want to wipe out filetypes across and entire drive...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2012 at 8:48 am
I think I've looked at the code for too long and can't see the obvious, can you please tell me where I am missing that?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2012 at 8:36 am
Viewing 15 posts - 1,201 through 1,215 (of 1,583 total)