Viewing 15 posts - 8,146 through 8,160 (of 9,725 total)
suresh.maddali (11/12/2009)
I have .mdf, .log files all those files are online, I conform with the following querry
select fg.name as FilegroupName, fg.type_desc as FileGroupType, df.name as...
March 17, 2010 at 4:43 am
I should add that the use of Partial Backups or File / Filegroup Backups (if you do use them) can be used to restore your tables if you happen to...
March 17, 2010 at 4:41 am
Point in Time restores (which is what you're referring to) cannot be done without starting from the last FULL backup. You can't re-apply Transaction Logs (or roll them back) to...
March 17, 2010 at 4:38 am
Wow, the pointer info is good information to have.
I do know that one of the options is to use the Agent version of the backup. The other is to use...
March 17, 2010 at 4:26 am
vidya_pande (3/17/2010)
Can you please give some references more information on how differential backup size increases because of Index Rebuilding process?I am not able to find any information on this.
I'm...
March 17, 2010 at 4:21 am
SQL Server will NOT allow you to restore files out of order. See my post about backup chains. You can read up about it in BOL too.
There's really nothing to...
March 16, 2010 at 12:56 pm
Ouch!
Might I recommend only using Differential on a daily basis (not an hourly) and backing up the Transaction Log on an hourly basis instead?
I've never seen Differentials as an "hourly"...
March 16, 2010 at 12:50 pm
I'm not sure if your 1:05 tran log backup is junk. Perhaps it would be useful to restore to point-in-time before the full backup completed.
Sorry -- my bad -- not...
March 16, 2010 at 12:41 pm
Or does SQL mindlessly try to do a Log file backup right during a Full backup? That would really mess things up, wouldn't it? What if it did a log...
March 16, 2010 at 12:33 pm
You could always set the status notification to run every 5 or 10 or X minutes and check to see if the job status / last run date & time...
March 16, 2010 at 12:08 pm
As I said, it sounds like the package hasn't "completed" when you're seeing the failure.
Can you attach a screen shot of the package when it's failed? I might be...
March 10, 2010 at 5:10 am
cRuchika,
FYI: I can't see whatever you posted in the scroll box.
Regarding a failed package but everything looks green or yellow? I've seen it before when a package has a task...
March 9, 2010 at 10:12 am
patwarimk (2/22/2010)
February 24, 2010 at 5:56 am
Thank you for this. I'm definitely voting on the connect item and will take a look at all suggestions as I really don't want to create a Gantt Chart Manually.
February 5, 2010 at 6:37 am
I did read the whole comment. It's just that the first paragraph of any email or post sets the tone for the rest of it. Which means your final comment...
January 26, 2010 at 10:32 am
Viewing 15 posts - 8,146 through 8,160 (of 9,725 total)