Viewing 15 posts - 5,671 through 5,685 (of 18,926 total)
Syed Jahanzaib Bin hassan (5/30/2011)
For the backup file curruption then you will use Verify the Backup on finished option and checksum option for the media test
Even that is not 100%...
May 30, 2011 at 5:54 am
The sql agent start the jobs as scheduled... what do you need to know?
May 30, 2011 at 5:51 am
2 things could have occured.
#1 Tempdb is set to have a starting size of 45 GB.
#2 tempdb has had to grow to that size to accomodate...
May 30, 2011 at 5:48 am
Syed Jahanzaib Bin hassan (5/30/2011)
@"Mr. Alphabet Soup":
It starts to get annoying to see replies with the "answer" being a lot shorter than the alphabet soup under your name. Sometimes you're...
May 30, 2011 at 5:43 am
Syed Jahanzaib Bin hassan (5/30/2011)
I am forced to ask the same questions again of you, Syed:
What in this query makes you believe that removing parallelism will enhance this query?
What query...
May 30, 2011 at 5:30 am
Markus (5/27/2011)
May 27, 2011 at 9:39 am
Here's how I do it. PS I don't use diff backups so I don't consider those but it'd be an easy change to implement.
SET IMPLICIT_TRANSACTIONS ON
SET DATEFORMAT YMD
SET STATISTICS...
May 27, 2011 at 9:28 am
Sean, no argument there :hehe:;-)!
May 27, 2011 at 7:30 am
blnbmv (8/21/2008)
I need help to make a cursor in a stored procedure to make it skip to the next id if that particular row has an error. and also...
May 27, 2011 at 7:16 am
Lucking out is lucking out :w00t:.
I'll deffer to your expertise but to me it looks like B.E. can be configured to do pretty much anything a maintenance plan can do...
May 27, 2011 at 6:58 am
Ya but it might pinpoint the exact datetime.
More to the point I had a similar issue that backupexec was doing the backups without anybody's knowledge. And the name of...
May 27, 2011 at 6:51 am
there's also the msdb backup history tables that might have a little more info (not sure about user tho).
May 27, 2011 at 6:44 am
halifaxdal (5/27/2011)
thank you for your reply.i created a new one w/ same setting, it works
Awesome, now just make sure you created the new user with the minimum rights in needs...
May 27, 2011 at 6:11 am
Sounds like a bad install file or some dll can't be installed.
Do you have admin rights on the machine?
Did you install with run as administrator?
Did you try redownloading the package...
May 27, 2011 at 6:10 am
Syed Jahanzaib Bin hassan (5/27/2011)
If you have multiple processors then useMAXDOP query hint option in the end of the query
how to apply query hint then visit on this link
How...
May 27, 2011 at 6:08 am
Viewing 15 posts - 5,671 through 5,685 (of 18,926 total)