Viewing 15 posts - 91 through 105 (of 115 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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
July 20, 2009 at 6:01 am
Cathy DePaolo (7/16/2009)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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. 😉
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
September 23, 2008 at 2:55 pm
los (9/22/2008)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
September 23, 2008 at 2:29 am
Viewing 15 posts - 91 through 105 (of 115 total)