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
640 reads
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
640 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
791 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,402 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,273 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,115 reads
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
871 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 Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers