Posts tagged sql
Microsoft SQL Server Backup Models
Dec 31st
master - simple -
model - full (default)
msdb - simple (default)
resource - none
tempdb - simple
Reference: http://msdn.microsoft.com/en-us/library/ms175987(SQL.90).aspx
When to Use the Simple Recovery Model
Use the simple recovery model if the following are all true:
Point of failure recovery is unnecessary. If the database is lost or damaged, you are willing to lose all the updates between a failure and the previous backup.
You are willing to More >
Seed Loading and Offloading
Mar 8th
So I’m trying to determine more efficient methods of remote backup solutions lately. Presently I am using Acronis True Image Echo Enterprise Server (9.7b8706) to test methods of backup. Here’s an example implementation:
Full Computer Backup
Normal Compression
Exclude SQL, Exchange, *.tmp, *.~, *.tib
Incremental Backup
Normal Compression
Exclude SQL, Exchange, *.tmp, *.~, *.tib
This is being executed on 8 More >
SQL Maintenance Tips
Jan 1st
dbcc checkdb (’databaseName’)
Verifies that Index and Data Pages are linked properly,
that Indexes are sorted, that the pointers in the database
are accurate, that the data looks OK, and that there are
proper page offsets.
Advanced checkdb Options:
NOINDEX, REPAIR_FAST, REPAIR_REBUILD, REPAIR_ALLOW_DATA_LOSS
noindex: Checks the database but not it’s indexes. Results in faster operation. If there are problems, make sure to More >
SQL Server Database Maintenance
Nov 12th
So, I’m a new kid on the block when it comes to SQL Server and I was in need of reindexing and defragmenting some tables in a database. I ended up finding a few commands useful for this operation.
dbcc indexdefrag and dbcc dbreindex
After running
dbcc showcontig
to get a report on density/fragmentation. I saw a lot of More >