Viewing 15 posts - 436 through 450 (of 1,271 total)
This is only documented in cases where there is no witness. Not possible (supposedly) if using a witness.
What happened in between? Was there a failover triggered or an outage or...
April 25, 2011 at 3:57 pm
Please describe in detail what happened.
April 25, 2011 at 3:29 pm
Mirroring supports database snapshots in Enterprise/Datacenter Edition. You can take a snapshot of the mirror database and provide a read-only point-in-time copy of the database for reporting purposes.
Database mirroring is...
April 12, 2011 at 8:26 pm
Just to reiterate, All I'm all, good article. Don't let my comments discourage you. Keep writing!!
April 12, 2011 at 12:19 am
Congrats on writing posting your first article!! I think it's a pretty good first article. There are a few points I'd like to clarify just to make sure the readers...
April 11, 2011 at 10:15 pm
Is this what you are looking for?
SELECT PRODUCTCATEGORY.IDPRODUCT,
PRODUCTCATEGORY.IDFIELD,
SQUERYTABLECATEGORY.NAMECATEGORY,
SQUERYTABLETYPE.NAMETYPE,
SQUERYTABLELINE.NAMELINE,
SQUERYTABLEQUALITY.NAMEQUALITY,
SQUERYTABLESIZE.NAMESIZEFROMTABLECONF,
CATEGORY.NAMEDESCRIPTION AS NAMECATEGORY,
TYPE.NAMEDESCRIPTION AS NAMETYPE
LEFT JOIN CONFIGURATION AS CATEGORY
ON PRODUCTCATEGORY.IDFIELD = CATEGORY.IDFIELD
AND PRODUCTCATEGORY.IDCATEGORY = CATEGORY.IDCATEGORY
And (Category.IDFIELD = 1
Or Category.IDFIELD Is...
April 5, 2011 at 1:43 pm
When switching to simple recovery model, you also lose the ability to perform file or filegroup or page level restores. For example, if I had a corrupted page in a...
March 15, 2011 at 11:27 am
Run DBCC CheckDB With EstimateOnly and verify that you have enough tempDB space. EstimateOnly will tell you how much tempDB space it estimates will be needed.
If not enough space, try...
March 7, 2011 at 12:07 pm
K Foster (2/23/2011)
February 23, 2011 at 9:27 am
GilaMonster (2/22/2011)
Maybe you should read my other article on transaction logs Managing Transaction Logs[/url]
Just read everything Gail has written, and you'll be a better DBA for it.
February 22, 2011 at 8:45 am
ceso (2/21/2011)
February 21, 2011 at 7:34 pm
david.howell (2/21/2011)
Running the first query I see Simple Recovery model and 'ACTIVE_TRANSACTION'
However, running DBCC OPENTRAN report "No active open transactions."
This doesn't seem to add up....
February 21, 2011 at 7:29 pm
Great article Gail!!
February 21, 2011 at 8:21 am
Log shipping is not expecting there to be a 3rd server. Most people store the backups local on the primary server. Generally, the expectation is that the directory with the...
February 2, 2011 at 10:27 am
You could do that, but I wouldn't recommend it. The most important step in the process is creating the log backup because you may need to use it in a...
February 1, 2011 at 11:24 pm
Viewing 15 posts - 436 through 450 (of 1,271 total)