Viewing 15 posts - 17,701 through 17,715 (of 49,552 total)
sqlskj4000 (7/10/2012)
What can be done so that the diff backups ignore the snapshots and treat the full backup as their checkpoint?
Ask the people running the snapshot backups to please...
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
July 10, 2012 at 2:15 pm
TempDB isn't likely to have functions, procedures or synonyms. As for tables and indexes, they'll be spread across all the files using proportional fill since TempDB can only ever gave...
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
July 10, 2012 at 2:01 pm
yup (7/10/2012)
Believe the 2 TB limit is for MBR partitions & no holds bar for GPT.
Nothing whatsoever to do with partitions or partition tables on disk.
The max size of a...
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
July 10, 2012 at 1:57 pm
No issues. Disables is much like dropping, just leaves the metadata behind
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
July 10, 2012 at 8:04 am
Depends on how critical you consider your backup history, job history, etc. Some people consider it critical enough to want full recovery and log backups, some 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
July 10, 2012 at 8:04 am
No.
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
July 10, 2012 at 7:47 am
Don't understand what you're asking.
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
July 10, 2012 at 7:27 am
Why would you want to?
What purpose would multiple files for master serve?
Why would you want all new databases to have multiple files?
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
July 10, 2012 at 7:02 am
Sourav-657741 (7/10/2012)
why not all the system databases are created with FULL Recovery model?
Master can't be in full recovery
TempDB can't be backed up
MSDB is not usually important enough to need point-in-time...
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
July 10, 2012 at 7:00 am
Master no, it can only ever be in simple recovery model, no matter what you set the recovery model to.
Model, yes you can take log backups, why would you bother?
MSDB,...
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
July 10, 2012 at 6:59 am
You can, but you're limiting your recovery options. If that latest full backup is damaged and not restorable, you'll have no alternate restore paths.
Personally I like to keep 2 full...
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
July 10, 2012 at 6:42 am
Yes. Non-buffer pool memory (thread stacks, backup buffers, linked server drivers, CLR and a couple other things). Usually about 500MB.
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
July 10, 2012 at 5:29 am
Something like that. Check Kimberly Tripp's Transaction Log Throughput article for the formulae for VLFs, make sure you get the number you want.
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
July 10, 2012 at 5:26 am
Sounds like a reasonable plan.
Find the quietest time you can, make sure that all of the active log is in the log file you want to keep, drop the one...
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
July 10, 2012 at 4:33 am
You can check sys.dm_exec_requests, see what's blocking the drop. You can check sys.dm_tran_locks for details.
There are some investigative scripts in chapter 6 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
July 10, 2012 at 4:24 am
Viewing 15 posts - 17,701 through 17,715 (of 49,552 total)