DR: SQL installed on new path, master restored, and SQL can't find resource database or start jobs!?!
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
644 reads
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
644 reads
Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...
2012-10-29
1,093 reads
Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...
2012-10-26
793 reads
SQL Server will not start.
You open up the ERRORLOG (...which I would only do with a text editor like gVim...
2012-10-25
1,407 reads
This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...
2012-10-24
1,274 reads
Through most of my career, I believed that at some point I would be able to learn enough and master...
2012-10-23
682 reads
Log shipping is great.
It's basically the act of beginning a restore with no recovery, and then restoring logs (with no...
2012-10-22
2,122 reads
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
872 reads
Hi everyone,
So the other day on twitter in #sqlhelp and privately with some friends at Microsoft and elsewhere I had...
2012-10-18
879 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers