Viewing 15 posts - 91 through 105 (of 114 total)
golden (7/20/2009)I think you should set your recovery model of the database into "simple" recovery instead of "full" mode.
:ermm:
Oh dear! There's that horrible piece of advice again. It's almost like...
July 20, 2009 at 9:22 am
Hi!
Why do you need to reduce the size of tempdb?
I mean, what exactly is happening and why is the size of tempdb a problem?
I don't know of any...
July 20, 2009 at 8:56 am
Shrinking the log every night sounds like terrible advice to me. More likely than not, the file will just have to grow again the next day and you'll only end...
July 20, 2009 at 6:01 am
Cathy DePaolo (7/16/2009)
July 20, 2009 at 3:28 am
Whooops... You generally can't restore a database from a newer SQL Server version to an older one because the system objects of the newer SQL Server database are incompatible with...
February 11, 2009 at 1:07 pm
Are you using the built-in Database Maintenance Plan feature to make these backups ?
If so, on the "Complete backup" or "Transaction log backup" sheet of the maintenance plan, simply check...
February 11, 2009 at 12:36 pm
Actually, you do not need to delete the older database in order to restore a new one from production - you can simply restore and overwrite what's already there. (RESTORE...
December 2, 2008 at 1:01 am
Ah, you're right, of course!
I should have said something more along the lines of "when updating, indexes may slow things down", then specified what I meant and how to avoid...
November 5, 2008 at 1:26 am
Michael Crider (5/1/2007)
This seems to happen when updating 2 very large tables (over 2 million)by joining them together. My process waits on a PAGEIOLATCH and goes to sleep and SQL...
November 3, 2008 at 1:53 am
Yes, it should, although I generally don't run full backups more often than once a day myself.
Basically, as long as it meets your needs, it's fine. 😉
October 15, 2008 at 4:51 am
vicky_j77 (10/12/2008)
I dont have any backup.
Oh dear, oh dear and INDEED oh DEAR!!!
I have nothing to offer except what's already been posted. Sorry.
Assuming the data is lost, your best bet...
October 15, 2008 at 3:15 am
Quicker to back up, yes, but not quicker to restore. You'll need your full backup from last Sunday and your latest diff backup - as opposed to just a full...
October 15, 2008 at 2:35 am
To this I can add that doing a regular log backup (ie. without truncate_only) does exactly the same thing - except that inactive log entries are backed up rather than...
October 15, 2008 at 1:08 am
Well, gee - oooops, it seems my information about differential backups was somewhat inaccurate then. (Thanks Gail for pointing that out.:P) A differential backup is a backup of all pages...
September 23, 2008 at 2:55 pm
los (9/22/2008)
September 23, 2008 at 2:29 am
Viewing 15 posts - 91 through 105 (of 114 total)