Viewing 15 posts - 8,131 through 8,145 (of 9,715 total)
Check Books Online for the system tables. In the Index, type in "sys" (without the quotes) and it will take you right to them. BOL gives you the table names,...
March 17, 2010 at 5:11 am
Also, if the folder destination does not exist, xp_cmdshell will NOT create it as part of the copy, unlike several other windows programs which will.
March 17, 2010 at 4:56 am
Usually when I get this error, another backup is actually running at the time. But it's only happened to me maybe two times, so "usually" might not mean anything.
March 17, 2010 at 4:55 am
You can definitely add more files to the Primary Filegroup without a problem. The issue is moving the data from the existing file to the new file.
The best way to...
March 17, 2010 at 4:53 am
starterm (3/17/2010)
March 17, 2010 at 4:47 am
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
Viewing 15 posts - 8,131 through 8,145 (of 9,715 total)