Viewing 15 posts - 12,961 through 12,975 (of 49,552 total)
When restoring, the first step is to create all the files at the same size as the source database for the backup had them, then copy the data from 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
May 30, 2013 at 1:09 pm
What is he using to do those backups?
With SQL Agent, if a job is still running at the time it would be scheduled to run again, it just doesn't start....
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
May 30, 2013 at 1:08 pm
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
May 30, 2013 at 1:03 pm
No. A restore always recreates the database as it was at the time of the backup. That includes the size of all 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
May 30, 2013 at 1:02 pm
Lynn Pettis (5/30/2013)
Stefan Krzywicki (5/30/2013)
Lynn Pettis (5/30/2013)
patricio.honore (5/30/2013)
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
May 30, 2013 at 12:50 pm
Brandie Tarvin (5/30/2013)
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
May 30, 2013 at 5:54 am
Need a new laptop. My little HP is starting to feel decidedly dated with only 3GB memory.
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
May 30, 2013 at 5:02 am
solomon.jernas (5/29/2013)
Any option shrink in mirrored db or only log backup will shrink the log size.
Log backups don't shrink the log, however if the log is full and growing,...
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
May 29, 2013 at 12:21 am
solomon.jernas (5/28/2013)
One of our production database is configured mirror , the log file growth around 150 GB, we need to shrink the log file
I suspect you need to 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
May 29, 2013 at 12:12 am
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the snapshot isolation levels. Financial or non-financial, I've never...
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
May 28, 2013 at 3:44 pm
Might be this
Or might not.
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
May 28, 2013 at 2:41 pm
Eugene Elutin (5/28/2013)
Nolock is a way of telling SQL Server that you don't mind if your data is slightly incorrect
...
Yeah, it can for example double count records:
Slightly incorrect in this...
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
May 28, 2013 at 11:21 am
Nolock is NOT an optimisation technique. If you're getting timeouts, tune your queries, tune your indexes. If blocking is a problem, tune your queries, tune your indexes and consider 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
May 28, 2013 at 10:18 am
No reason (and dropping the index will invalidate any plans which used it)
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
May 28, 2013 at 10:10 am
Steve Smith-163358 (5/28/2013)
Is this a common setup as I've never seen it before?
No.
Is there any advantage to using Transaction Log Backups, rather than Differential Backups?
No
Also, are there any major drawbacks...
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
May 28, 2013 at 10:08 am
Viewing 15 posts - 12,961 through 12,975 (of 49,552 total)