Viewing 15 posts - 1,201 through 1,215 (of 1,584 total)
No such luck in this case :(. With the checkdb not being able to create the snapshot sounds to me like a reboot is needed. Having to go this...
February 21, 2012 at 11:35 am
"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...
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,...
February 21, 2012 at 9:45 am
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...
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;...
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:...
February 20, 2012 at 8:02 am
Use a script task (just to see if that works) something like:
Public Sub Main()
Try
...
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)
February 16, 2012 at 2:06 pm
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)...
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
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....
February 13, 2012 at 2:21 pm
Is this a local drive or a networked backup location? Seems risky to want to wipe out filetypes across and entire drive...
February 13, 2012 at 8:48 am
Viewing 15 posts - 1,201 through 1,215 (of 1,584 total)