Viewing 15 posts - 331 through 345 (of 355 total)
Try this
--This script pulls all data and log files
--associated with any user db's
BEGIN
CREATE TABLE #FILEINFO
(DatabaseName VARCHAR(100),
PhysicalFileName NVARCHAR(520),
FileSizeMB INT,
Growth VARCHAR(100))
DECLARE @command VARCHAR(5000)
SELECT @command...
August 31, 2009 at 3:28 pm
Performance Dashboard is $
...as in very good
August 26, 2009 at 4:20 pm
hehe, I just looked at the topic, then my favorites 🙂
August 25, 2009 at 2:08 pm
A) You should be running transaction log backups for mirrored dbs if they are using that sort of recovery model
B) I believe if you shrink the transaction log on the...
August 25, 2009 at 12:29 pm
August 25, 2009 at 12:17 pm
you have duplicated this post http://www.sqlservercentral.com/Forums/Topic774611-146-1.aspx
August 20, 2009 at 4:09 pm
August 20, 2009 at 4:06 pm
how many pages are there?
August 20, 2009 at 2:18 pm
August 20, 2009 at 12:24 pm
I think you need to Enable AWE, in SQL, on 64-bit systems if you want to use lock pages in memory.
There is an issue in MS SQL 2008 SP1 with...
August 20, 2009 at 12:23 pm
August 20, 2009 at 12:17 pm
I'm not sure what you mean by
...the right sequence or not.
The MSDN article I referenced will take you through step by step.
you may be able to ping the box...but...
August 20, 2009 at 10:42 am
Make sure you restore the full from the same bak on both the principle and the mirror then take a trn on the principle xfer it and restore on the...
August 19, 2009 at 10:06 am
Viewing 15 posts - 331 through 345 (of 355 total)