Viewing 15 posts - 136 through 150 (of 605 total)
Greg's spot on. Its not just restoring the database. A full test of the applications, reports & processes is required for DR.
As the database is not in production...
February 4, 2009 at 2:08 pm
Not really material to my being a DBA, but I built our SQL Server systems from the ground up at my last employer. Everything I learned initially was from...
February 4, 2009 at 11:57 am
What do you want to simulate? Hardware failure? Database corruption?
You also mentioned you have only 1 box. Did you mean you have just 1 database server which...
February 4, 2009 at 11:07 am
If you want it running all of the time, the obvious choice is a trigger against the sysjobhistory table - however, I'd not recommend you start putting triggers in the...
January 30, 2009 at 7:01 am
You can add the query into the @query parameter.
However, if you are holding all failed jobs in this table, you will need to put in some data check filter. ...
January 30, 2009 at 5:49 am
As it stands, I'm not 100% sure if we'll be looking at SQL2008. We currently run SQL2005 and SQL2000.
However, the long term strategy is MySQL for licensing cost reasons....
January 30, 2009 at 5:43 am
No - well not as far as I am aware. There could be some 3rd party tool to manage this?
I suppose you could have an alternate connection string in...
January 30, 2009 at 5:15 am
Also, why don't you also consider setting up the notifiications on the scheduled jobs to send an e-mail when the job fails rather that querying the tables to look for...
January 30, 2009 at 5:07 am
Yes, it can.
Set up a scheduled job and take a look at sp_send_dbmail.
January 30, 2009 at 5:04 am
Hi,
You are correct. This is an ownership chain issue. You will need to grant select permissions on the objects in the production data.
Also, with regards to indexed views,...
January 30, 2009 at 5:01 am
Nice article. It was an interesting read. I have been the "Hero DBA" and as a result, I was still getting calls or e-mails six months after I...
January 27, 2009 at 11:34 am
Well, as I suggested, you need to get your network team involved - junior or not - they are still in a job for their network knowledge.
They need to see...
December 4, 2008 at 1:55 am
Are you using bcp or BULK INSERT?
201st column - yikes!
Do you have any documentation for the data you are inserting? ie..Does the 201st column data type in the documentation...
December 3, 2008 at 8:03 am
Are you getting this error in any other place?
Check the windows logs over and speak with your network team.
December 3, 2008 at 7:55 am
Viewing 15 posts - 136 through 150 (of 605 total)