Viewing 15 posts - 241 through 255 (of 346 total)
Your request isn't entirely clear. Are you saying you want to setup log shipping & want to know how to monitor it, that you've got log shipping already and...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 18, 2008 at 2:47 pm
You could try creating your own version of sp_help_job. Just script the existing one to a new window as CREATE, change the name and fiddle the output to go...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 14, 2008 at 6:57 pm
Your statistics were probably out of date. Running the UPDATE STATISTICS command would've been a better command to use (first) rather than rebuilding the index.
You should regularly...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 4:02 pm
The MS Best Practices Analyzer is a start. You can get it from here:
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 2:56 pm
@Strommy: In my last job we used NetIQ. A lot easier than Tivoli. You just have to watch out for adjusting child jobs - any changes to...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 2:52 pm
Are you talking about truncating or shrinking?
Truncating is only applicable to log backups.
Shrinking can apply to data and log files but not backup files.
If the backup file is...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 2:22 pm
Not quite. A full backup will backup the database and enough of the log to recover the database when it is restored, but it will not truncate the log....
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 2:15 pm
It's all in BOL but is a bit spread out. When I did my one, I started by copying & pasting stuff out of the various BOL pages into...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 1:57 pm
I have local admin rights to my SQL Servers (using a domain account specifically for doing DBA stuff, not my personal LAN account). The service account shouldn't have local...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 11, 2008 at 1:45 pm
Detaching and reattaching should do it (without having to fiddle with anything else). Being SQL 2005, you can't update the system tables manually. If it's SQL 2000, you've...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 6, 2008 at 5:58 pm
Timothy Ford (2/6/2008)
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 6, 2008 at 3:25 pm
For job monitoring, I just get each server to send an email (per job) when a job fails. DBMail on SQL205, SMTP stored proc for 2000.
As far as auditing...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 6, 2008 at 1:37 pm
Stop the application using the sa login for a start. And when you do, change the password.
Try and architect your application to use either Windows Authentication or an application...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 16, 2008 at 6:03 pm
Are you worried about the impact on the monitoring server or the servers you are monitoring?
Are you using server-side traces or profiler? If profiler, then the monitoring...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 16, 2008 at 5:54 pm
I think the best you could do is monitor for it and take corrective action (make sure your backups are current!).
Begs the question though - if you are concerned with...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 13, 2008 at 3:20 pm
Viewing 15 posts - 241 through 255 (of 346 total)