Viewing 15 posts - 5,146 through 5,160 (of 19,564 total)
I prefer to take more caution. I can see the reason for wanting to do it that way, but I prefer to take a full backup and restore that...
January 17, 2013 at 3:41 pm
There is a way, but while hashing that out I just want to bring up a preference. I prefer to have the date and time on the backup files...
January 17, 2013 at 3:33 pm
Quantum is certainly highly ranked as far as Backups to tape go.
Backing up SQL Server direct to tape will generally take a while. As far as speed and deduping,...
January 17, 2013 at 3:20 pm
Here's a good article on tempdb configuration
There is a recommendations section you should check. Along with the recommendations, read the section on tracking tempdb contention. This should help...
January 17, 2013 at 3:11 pm
crookj (1/17/2013)
SQLRNNR (1/17/2013)
JAZZ Master (1/17/2013)
EL Jerry (1/17/2013)
SQLRNNR (1/17/2013)
crookj (1/17/2013)
SQLRNNR (1/17/2013)
Stuart Davies (1/17/2013)
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
Frankie Santana
carlos santana
Santana Moss
Kate Moss
The Matrix
SPOONS
Left Handed Wooden Spoon
Right handed 2 prong metal fork
January 17, 2013 at 3:03 pm
JAZZ Master (1/17/2013)
EL Jerry (1/17/2013)
SQLRNNR (1/17/2013)
crookj (1/17/2013)
SQLRNNR (1/17/2013)
Stuart Davies (1/17/2013)
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
Frankie Santana
carlos santana
Santana Moss
Kate Moss
The Matrix
SPOONS
January 17, 2013 at 3:00 pm
Tara-1044200 (1/17/2013)
January 17, 2013 at 2:49 pm
No. You should do it during a maintenance window or after business hours.
January 17, 2013 at 12:33 pm
You could do that, but the index job will cause it to grow again.
January 17, 2013 at 12:27 pm
Establish and Enforce standards
January 17, 2013 at 10:09 am
Hugo Kornelis (1/17/2013)
chgn01 (1/17/2013)
Aliases are not for columns where there is only one column possible.
You are completely right - if you never make typo's, never have anyone else changing your...
January 17, 2013 at 9:48 am
crookj (1/17/2013)
SQLRNNR (1/17/2013)
Stuart Davies (1/17/2013)
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
Frankie Santana
carlos santana
Santana Moss
January 17, 2013 at 9:46 am
Stuart Davies (1/17/2013)
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
Frankie Santana
January 17, 2013 at 9:38 am
Sean Pearce (1/17/2013)
SQLRNNR (1/16/2013)
Index MaintenanceBackups
Integrity Checks
Deadlock monitoring
Don't forget to restore those backups.
Very true
As the saying goes, you don't have a backup until you have test restored it.:-D
January 17, 2013 at 9:30 am
Viewing 15 posts - 5,146 through 5,160 (of 19,564 total)