Viewing 15 posts - 8,131 through 8,145 (of 9,720 total)
Please answer the other questions so we know what you've checked and what you haven't checked. Otherwise, we can't help you further.
March 17, 2010 at 9:07 am
Your post is a little hard to read, so forgive me if I don't quite understand the problem.
Is it just Maint. Plans that are taking forever or is it all...
March 17, 2010 at 8:01 am
parthi-1705 (3/17/2010)
March 17, 2010 at 7:57 am
That's actually a pretty good idea. The only thing to keep in mind, though, is that it will potentially stripe the data across the files or shove them all in...
March 17, 2010 at 7:47 am
You do realize you can get better performance out of your DB if these LUNS really are separate drives (physically speaking) and you apportion out your tables properly, right? This...
March 17, 2010 at 7:03 am
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
Viewing 15 posts - 8,131 through 8,145 (of 9,720 total)