Viewing 15 posts - 961 through 975 (of 1,583 total)
What errors are you getting?
Also, what result do you get after running DBCC CHECKTABLE( 'YOURDB') WITH ALL_ERRORMSGS , NO_INFOMSGS on the subscriber?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 26, 2012 at 1:14 pm
If it's imported to Excel why not leave the format alone as you pull it out of SQL Server and have a macro in Excel to do all the formatting...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 21, 2012 at 7:01 am
Glad it helped 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 3:42 pm
What about when you turn on the extra logging?
You can try to log more contents of the failing Agent job but opening up the Job, going to the Step (should...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:43 pm
+1 Gila...she beat me to the draw!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:23 pm
penu.v8 (11/20/2012)
i dont understand err:
Problems with the query, "ResultSet" property not...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:21 pm
Also, which Service Pack do you have installed?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:11 pm
Did any permissions change? Perhaps with your Tech Services team? Was the account being used to execute your SQL Agent jobs recently change? Perhaps it was in the local...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:10 pm
So this used to work before? Sorry if i misunderstood your original post...
Since it works when you run it manually, it makes me think that the execution/proxy account for...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 2:06 pm
penu.v8 (11/20/2012)
heyty for your response
but as i said i can see the back up files are being created but i see the job being failed.
with the err msg
Yes, but...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 1:50 pm
Try executing it via a query window, also, have you verified no errors in the System Event Viewer? One last thing, are you 100% positive there is adequate space...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 1:44 pm
Try running the actual TSQL needed to run the backup from SSMS, the error outputted by the SQL Agent job isn't always very descriptive. Also in the past, I've...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 1:41 pm
How about SELECT CONVERT(VARCHAR(25), GETDATE(), 22)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 20, 2012 at 1:18 pm
No problem, hope it works out for you 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 19, 2012 at 11:45 am
Verified that the strip-size is 64k.
I think for the next few days I am going to try running it as a RAID 5, then move things around, redo the array...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 16, 2012 at 7:51 am
Viewing 15 posts - 961 through 975 (of 1,583 total)