Viewing 15 posts - 12,361 through 12,375 (of 49,557 total)
Replication is not deprecated.
Technically it's not a HA solution. It can however be used for HA in some cases.
July 16, 2013 at 1:28 am
poratips (7/15/2013)
Is it virtualization is good or stand alone server hardware is good?
Virtualisation's fine, stand alone hardware's fine, depending on what you're doing
Is it 8 core/CPU is enough?
No way to...
July 16, 2013 at 1:27 am
After a service pack installation. This isn't a replacement for database backups (which you need to do regularly). It's as well as.
July 16, 2013 at 1:25 am
Welsh Corgi (7/15/2013)
Yes. It is a backup that can be used for PIT recovery.Am I missing something?
Yes, that you have the NORECOVERY option on the log backup. i.e. back up...
July 16, 2013 at 1:25 am
Welsh Corgi (7/15/2013)
GilaMonster (7/15/2013)
What is the exact backup command that's been run?
BACKUP LOG DataWarehouse TO DISK e= N'D:\Backup\TransactionLog\Data\DataWarehouse_backup_2013_07_15_181847_8601173.trn'
WITH NOFORMAT, NOINIT,
NAME = N'DataWarehouse_backup_2013_07_15_181847_8601173',
SKIP, REWIND, NOUNLOAD, ...
July 15, 2013 at 4:36 pm
What is the exact backup command that's been run?
July 15, 2013 at 4:03 pm
As I said earlier...
GilaMonster (7/15/2013)
July 15, 2013 at 10:47 am
Well they can't just 'go suspect'
Suspect mode requires that SQL encounters corruption during a transaction rollback or during crash recovery. Typically, because the system databases (other than MSDB) aren't changed...
July 15, 2013 at 9:05 am
Then the correct answer would be 'There are no other sensible ways of doing it.'
July 15, 2013 at 8:32 am
As I said, to fix fragmentation you have to either rebuild the index or reorganise the index.
July 15, 2013 at 7:12 am
If SQL cannot open and recover master and model successfully, SQL's startup process will fail. If MSDB can't be opened and recovered, SQL Agent will not be able to run.
July 15, 2013 at 6:52 am
Are you sure the fragmentation is the direct cause of the poor performance?
To fix fragmentation, rebuild or reorganise the index.
July 15, 2013 at 6:44 am
ananda.murugesan (7/15/2013)
But actucal exec.plan high seek 94% which created new index on that table...
Why are you fixated on the cost % of the index seek in the plan?
July 15, 2013 at 6:37 am
Viewing 15 posts - 12,361 through 12,375 (of 49,557 total)