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...
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....
May 30, 2013 at 1:08 pm
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.
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)
May 30, 2013 at 12:50 pm
Brandie Tarvin (5/30/2013)
May 30, 2013 at 5:54 am
Need a new laptop. My little HP is starting to feel decidedly dated with only 3GB memory.
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,...
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...
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...
May 28, 2013 at 3:44 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...
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...
May 28, 2013 at 10:18 am
No reason (and dropping the index will invalidate any plans which used it)
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...
May 28, 2013 at 10:08 am
Viewing 15 posts - 12,961 through 12,975 (of 49,552 total)