Viewing 15 posts - 12,001 through 12,015 (of 49,552 total)
Fal (8/22/2013)
We were thinking of getting a stone benchtop,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 3:01 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 4:07 pm
HanShi (8/22/2013)
and perform a consistency check on the databses.
There is no consistency check performed at startup or automatically at any other time. The only time SQL performs a consistency check...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 1:33 pm
Jason.Reeves (8/22/2013)
Do a alter database or detach/reattach and move all the inactive or offline databases to a disk not part of the cluster.
A clustered SQL Server's database files must always...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 12:04 pm
If those inactive databases are never used, you can take them offline. If they're offline, SQL won't open or recover them on startup.
Still, with thousands of databases you're looking at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 12:00 pm
Ordinal position is the position within the create table statement and in the metadata, hence the default position when doing a select *. That's it. It has no bearing on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 11:58 am
Log backups as well?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 6:26 am
Is once a month often enough? Do you retain all your backups (full and log for month)? If not, what do you plan to do if the CheckDB picks up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 4:54 am
Restore from a clean backup. That's not repairable.
If you have an unbroken log chain from the clean backup then you won't lose any data (you can take a tail-log backup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 4:44 am
What are you partitioning for? What's the goal?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 4:31 am
Backups do not automatically fail. You have to explicitly add the option to the backup statement to check the checksums. Maintenance plans don't allow that option and most people don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 4:29 am
Having 10MB as the target number does not mean that the log will shrink to 10MB, only that 10MB is the minimum. If say the log has 25MB of log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 3:46 am
First problem there, the database snapshot for CheckDB can't be created. Is that an NTFS drive, does the SQL Server service account have full permissions to the folder with the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 3:45 am
Sounds right, but check with a sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 3:35 am
ananda.murugesan (8/21/2013)
Can we kept CHECKSUM option in database Instead checking every week DBCC CHECKDB?
No.
Well, you can do it, but it will give you absolutely no knowledge about whether the database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2013 at 3:32 am
Viewing 15 posts - 12,001 through 12,015 (of 49,552 total)