Viewing 15 posts - 38,131 through 38,145 (of 49,571 total)
Lynn Pettis (6/27/2009)
June 28, 2009 at 2:51 am
You're only restoring the full backup there hence only the full backup will be restored. To get to 9AM, you have to explicitly restore the 8AM diff and the...
June 28, 2009 at 2:50 am
Try restarting the service again, not single user, just normally. If things still don't come right, I would suggest that you contact Microsoft's CSS people. They will charge, but they're...
June 28, 2009 at 2:48 am
Lynn Pettis (6/27/2009)
3NF -- The Key, The Whole Key, and nothing but The Key.
Didn't realise anyone else knew that mnemonic. I learnt it at university as an easy way to...
June 27, 2009 at 3:34 pm
Looks good.
I know there are scripts around (google should find) that can build a full restore script from the backup records in msdb when all the backups are to...
June 27, 2009 at 2:31 pm
Lynn Pettis (6/27/2009)
GilaMonster (6/27/2009)
Could well be. Should I reply with some relational theory?
Sounds like a plan to me. I couldn't, it's been so long I just barely remember anything...
June 27, 2009 at 2:30 pm
Eros (6/27/2009)
Surely, "TRUNCATE TABLE" gave me a very impressive quick response "Command(s)...
June 27, 2009 at 1:02 pm
rambilla4 (6/27/2009)
1.Backing up the Full, Diff and Log backups to the same backup device(PROD_06-25-2009.bak) is Preffered? or
2.Backing up the Full to Z:\Backups\Full\prod.bak
Backing up the Diff...
June 27, 2009 at 12:49 pm
It should be
RESTORE HEADERONLY FROM FILE = < Backup file location >
You're not restoring from a database, you're restoring from a file.
p.s. Backing up multiple different backup types to the...
June 27, 2009 at 11:22 am
Threads once posted can't be deleted. If you post in the wrong forum, either note it in the post and request the mod to move it (via Report), or post...
June 27, 2009 at 11:20 am
Could well be. Should I reply with some relational theory?
June 27, 2009 at 10:14 am
An interesting response here. Anyone understand what he's asking?
http://www.sqlservercentral.com/Forums/Topic743113-391-1.aspx
June 27, 2009 at 9:52 am
Could you perhaps clarify and expand on your question so that someone can help you?
June 27, 2009 at 9:47 am
John (6/27/2009)
If you have a STATS_DATE of NULL, does that always mean you should skip running update stats on an object?
As far as I'm aware, Stats_date of NULL means that...
June 27, 2009 at 9:46 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic743117-5-1.aspx
June 27, 2009 at 9:42 am
Viewing 15 posts - 38,131 through 38,145 (of 49,571 total)