Database Maintenance Plan
TO Database Maintenance Plan
- Database Integrity: The Check Database Integrity task performs internal consistency checks of the data and index pages within the database.(Must need to have on all server)
- Shrink Database: The Shrink Database task reduces the disk space consumed by the database and log files by removing empty data and log pages.- (if need run manually- Shrink Database may cause performance issue )
- Reorganize Index: The Reorganize Index task defragments and compacts clustered and non-clustered indexes on tables and views. This will improve index-scanning performance. – Create Individual Jobs.-- may cause performance issue)
- Rebuild Index: The Rebuild task reorganizes data on the data and index pages by rebuilding indexes. This improves performance of index scans and seeks. This task also optimizes the distribution of data and free space on the index pages, allowing faster future growth.- Create Individual Jobs-- may cause performance issue)
- Update Statistics: The Update Statistics task ensures the query optimizer has up-to-date information about the distribution of data values in the tables. This allows the optimizer to make better judgements about data access strategies.- Create Individual Jobs
- Cleanup History :The History Cleanup task deletes historical data about Backup and Restore, SQL Server Agent, and Maintenance Plan operations. This wizard allows you to specify the type and age of the data to be deleted.-- Create Individual Jobs
- Execute SQL Server Agent Job: The Execute SQL Server Agent Job task allows you to select SQL Server Agent jobs to run as part of the maintenance plan.
- Back Up Database (Full): The Back Up Database (Full) task allows you to specify the source databases, destination files or tapes, and overwrite options for a full backup.-
- Back Up Database (Differential):The Back Up Database (Differential) task allows you to specify the source databases, destination files or tapes, and overwrite options for a differential backup.-
- Back Up Database (Transaction Log):The Back Up Database (Transaction Log) task allows you to specify the source databases, destination files or tapes, and overwrite options for a transaction log backup.
Faiz Farazi
MCDBA
Reply:
------------------------------------
Reply:
Faiz,
Are you making a suggestion in regards to what should and shouldn't be included in the set of maintenance tasks? If so, please include a description in the future to provide some context to the readers.
Thanks,
Patrik
------------------------------------
Reply:
------------------------------------
Issue accessing elearning site (writing secure code ebook offer)
I reloaded the page (it kept me signed in) but when I went to try again, it said my access code had already been used, and did not allow me past that initial screen.
Is there a way to reset my code? (code blanked below for security, but I wanted to include the link for troubleshooting).
Thank you,
Keith
Free E-Book Offer: Writing Secure Code, Second Edition, by Michael Howard and David LeBlanc <
http://go.microsoft.com/?linkid=9400745>Discover the best practices for writing secure code and stopping malicious hackers in their tracks - direct from the top security experts at Microsoft! Through August 27, you can download the e-book of Writing Secure Code, Second Edition for free. This offer requires a valid Windows Live ID and the access code XXXX-XXXX-XXXX. Download the e-book today. <
http://go.microsoft.com/?linkid=9332105>Reply:
The bad news is that on my system (IE 6, recently upgraded to XP SP3), I'm unable to download any of the chapters or the book. Clicking on the link starts the download, but after clicking on either Save or Load, the file download dialog pops up with "Internet Explorer cannot download ...35617223_SecureCode_eBook.pdf from www.microsoftelearning.com
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later." Has anyone else had _this_ problem?
------------------------------------
Reply:
I found the book under my learning, and when I clicked on it (the whole book, not individual chapters), it brought it up in a pdf browser window, from which I was able to save a local copy no problem. I don't have SP3, and am behind a corporate firewall. I do have a relatively recent full version of Adobe Acrobat installed (the full version, not just the reader).
My best guesses would be to install the lastest adobe pdf reader, and try the link for the full book download.
Good luck, and thanks again for the info on the link location.
Keith
------------------------------------
Forums' edit frame doesn't scroll
When I'm creating a post in one of these forums the page has two "frames" (for want of a better word) - a narrowish one at the top and a larger one at the bottom which contains the edit control and the Post Options control. If my browser (IE7) isn't wide enough to display everything and I try to use the scrollbars, I find that only the top frame responds to the scrollbars.
The problem is exacerbated the smaller my browser window becomes. If I make its height too short for the edit control, then the top frame actually overlays over the top of the bottom frame.
This is totally unacceptable. My screen resolution is 1024 x 768 (yes, there are plenty of developers stuck with primitive monitors out there, even in big companies) and I use a vertical taskbar and I don't have enough available width for this. Heaven help some poor sod with a vision defect who needs to use a lower resolution. Courts nowadays view accessibility issues as discrimination, so I recommend you add this to your "to do" list.
Reply:
-Andrew
------------------------------------
How to pass the values as querystring to the hyperlink column in a datagrid
Dear Freinds
we can pass the values in hyper link
add the hyperlink column navigateurlformatstring as
DataNavigateUrlFormatString="RegisterNewEdition.aspx?emailid={0}"
so first data column value is passed to the url as query string value..
Regards
Ravishanker
Reply:
In any case, you would set the DateNavigateURLField equal to the column name you would like inserted in the parameter and the DataNaviageURLFormatString equal to the string you want presented. In other words, if the column emailid is what contains the value you would like passed you would use the following:
DataNavigateUrlField: emailid
DataNaviageUrlFormat: ~/RegisterNewEdition.aspx?emailid={0}
Of course, then you would want to set your sort expression, your text header, any other formating that you would like etc...
Hope this helps.
Eric
------------------------------------
XP SP3 Works for me
Got the Microsoft Updates Ready To Install prompt two days ago and ran the SP3 update on my HP Pavilion Laptop. My laptop had been running a bit sluggish lately. After running SP3 I've noticed a remarkable improvement in performance. Quicker boot times, faster response time launching programs, etc.
I run Norton Internet Security and SpyDoctor on my machine and am very conscious about keeping it tuned (defragged, virus/spybot scanned, driver updates, patched, etc). I'm a computer security engineer.
If you've been taking care of your computer as well as you do your car or home, most of you won't notice anything but an improvement in performance.
This is my experience.
Opening a 2.0 Website remotely
Hello,
Here is the situation:
IIS6
Sharepoint 2003 installed (1.1) with sharepoint services related
I have sharepoints portal running on the IIS6.
I have also another application using 2.0 Framework. I created another pool for this application, this pool runs the 2.0 framework.
My problem is the following : I just cannot open this 2.0 website remotely.
When I open it, it says that "The version of windows sharepoint services running on the server is more recent the version of Frontpage you are using. You need a more recent version of Frontpage"
Well, I don't want to install the Frontpage.(I have sharepoint designer installed)
Then I tried to create a new website directly on the server using visual studio and it says :"the visual web developer does not support sharepoint website".
It's really annoying, to access object model of sharepoint I need to run the website on the sharepoint server. The solution would be to publish but it would be very boring as I cannot debug in the normal way, I will loose so much time.
Any help would be appreciated
Thx in advance
Reply:
------------------------------------
Reply:
I installed the FrontPage extensions and It didn't get any better.
Can somebody help me on this? it's a blocking problem for me and I really need to get it working.
Thx in advance
------------------------------------
Reply:
UP!
Thx
------------------------------------
Reply:
If sy can help me on this
just explain me how it is possible to open remotely a website 2.0
------------------------------------
FCS SP1 Released !
Today we are pleased to announce the availability of Forefront Client Security Service Pack 1 (SP1).
FCS SP1 adds support for:
Agent protection on Windows Server 2008 – both Server and Core.
Server role support on Windows Server 2008 (server only) for FCS server components.
FCS Enterprise Manager on Windows Server 2008 (server only).
To obtain FCS SP1, first install FCS. After successfully installing FCS, you will be offered SP1 via Microsoft Update. For more information, read the FCS SP1 Release Notes (http://go.microsoft.com/fwlink/?LinkID=126287) or see Microsoft Knowledge Base article 951951 (http://support.microsoft.com/default.aspx/kb/951951)
Wireless Card No connection after SP3
After installing Win XP SP3 today (through my "Automatic Update" tool, my wireless card decided to stop working. I tried refreshing my network list, etc, etc. but to no avail. I have a intel(R)PRO/Wireless network card on my IBM Lenovo T60. After visiting this and other forums and seeing the same problems over and over again, I decided to uninstall SP3 just to see if my wireless card would work again. After uninstalling the software, and rebooting, my wireless card still did not work. It was showing "Wireless network not connected" and did not show any available networks at all (becuase it was not connected). So I went into the "Connect To" menu, and checked out my wireless networks - none available. Out of pure curiousity, I opened up the "Wireless Network Connections Properties" and under the "General" tab, double clicked on the "configure" button. After doing that, my Intel "Advance" window opened up and there was a grey button on the upper right hand side that said, "Wireless Off" - I clicked on that, and it went to "Wireless On". After that, my wireless card started working again.
I am not sure if my wireless Intel Pro card just automatically turned "off" after installing SP3, but to be sure, I really don't want to risk it again. I think I will wait a little while before installing this service pack. Hopefully some of you will find this helpful. I'm not a computer whiz, but I am sure glad my wireless is working again.
Cheers
Elle
SCCM and WSUS
I have posted some other posts in different sections of technet, and was advised by Wally Mead to put some comments regarding documentation into this section.
I have read and read and read for months and it feels like and I am still uncertain as to how to setup WSUS to be used with SCCM. The WSUS documentation doesn't really apply as SCCM takes over control and the SCCM documentation doesn't really seem to follow for us in our setup. 1x Primary SCCM and 2x Secondary SCCM Servers.
I am really unsure about the setting "Active Software Update Point", I originally thought that every SCCM server in our hierarchy would be an active software update point, Primary set to sync from MS and secondary's set to sync from the primary.
We must of reinstalled WSUS, all the SUPs and the WSUS database about a dozen times and we still cant seem to get it to work properly. I don't like to be negative, but the documentation feels like it's lacking for this area to me. Please see the following post for more info on our troubles.
At the end of post:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2472915&SiteID=17
I mention:
I have got to be honest and say that the documentation for this part of SCCM, feels incomplete as I seem to have a lot of uncertanties left in my mind as to how things should be configured. Sorry for the criticism Microsoft, but hope you see it as constructive criticism.
Reply:
Kev,
I agree that the docs are somewhat confusing in this area but they are actually also accurate. I had to read them several times before it finally clicked for me. Of course Torsten commented last week that it made perfect sense to him so I just assumed I was a little slow :-)
Each primary site needs 1 and only 1 ASUP. Child secondary sites can have the SUP role on them but, for lack of a better way to say this, each client assignable site code can only have 1 ASUP. The most common way you will see this done is the central site server is the ASUP, child secondary sites are SUP and child primary sites are ASUP
I have helped serveral people get this working, once I even did a webex with a guy and installed the whole software updates portion for him because he was having so many problems getting it working. It took me about an hour to do that. If you still can't get it and need help shoot me an email offline and I am more than happy to call you and help you get it going. My email address is firstinitiallastname at myitforum dot com
------------------------------------
Server 2003 Network Share Hang
I have the same problem for at least 2 different set of server 2003 R2 SP2, It hangs intermittently, nic card use include linksys line100txv.5, boardcom... it still hang even after driver update... some hangs while they try to save excel file, and some custom program... epsecially those file or program that is constantly share by everybody.. think it is a sp2 issues. only a reboot will solve the problem temporary... just disable network threat protection & Proactive protection for Symantec Endpoint...
Ken
WSS 2.0 Search function missing
I have SBS 2003 which comes with Sharepoint 2.0. I have created a document library, but I can't find any way to search the documents in the library. I have found references to the search function in help, but I can't find the web part anywhere or anything else that looks like a search tool.
Can anyone explain this to a newb?
Cheers
Dave
Reply:
I assume this is also present in SBS 2003 systems running WSS 2.0 although the WSS 2.0 implementation is somewhat different there.
There's a SBS newsgroup at microsoft.public.windows.server.sbs in case the above doesn't help you.
------------------------------------
Reply:
Further research suggests that if you are running WSS 2.0 on MSDE rather than SQL Server, the search function is not supported. If anyone could confirm this I'd appreciate it.
------------------------------------
MOSS absence template
Thanks in advance...
Sean
Software distribution fails on sites after upgrading from SMS2003 to SCCM2007
This may be of use to someone out there.
When we recently upgraded from SMS2003 to SCCM2007 we were unable to deploy software from any site. On checking, policy was making it through to the clients and they knew where the distribution and management points were. One of the Management Point logs, MP_Location.log located at MPServerNAme\Drive\SMS_CCM\logs had the following error appearing repeatedly:-
MPDB ERROR - CONNECTION PARAMETERS
SQL Server Name : SiteServerName
SQL Database Name : SiteDatabaseName
Integrated Auth : True
MPDB ERROR - EXTENDED INFORMATION
MPDB Method : ExecuteSP()
MPDB Method HRESULT : 0x80040E07
Error Description : Conversion failed when converting the varchar value 'LON' to data type int.
OLEDB IID : {0C733A63-2A1C-11CE-ADE5-00AA0044773D}
ProgID : Microsoft OLE DB Provider for SQL Server
MPDB ERROR - INFORMATION FROM DRIVER
SQL Server Name : SiteServerName
Stored Procedure : MP_GetContentDPInfoProtected
Native Error no. : 245
Error State : 1
Class (Severity) : 16
Line number in SP : 40
In the end the cause was tracked down to the SQL database tables. The specific table was "ContentDPMap" where in the design the "ServerPath" field was out of sequence. It should have been between the "ServerName" and "SiteCode" fields. When this was corrected we were able to distribute software to clients.
Reply:
Be cautious as going into the site database and modifying ANYTHING is unsupported unless you are working with product support and they are helping you. Otherwise you can do very bad things and essentially hose your database.
I don't know if product support was consulted in this situation, but if not, you should always do so before doing anything manually in our site database.
------------------------------------
Sharepoint Configration Wizard
I have a new farm that I'm planning to migrate content to and installed a hotfix on a specific problem I was having with content deployment.
The specific installation of the hotfix is not the issue, I just wish there was a way to determine why the wizard fails when you run it for a upgrade or whatever. The logs dont tell you anything.
Reply:
------------------------------------
Using multiple scopes with fulltextsqlquery
Can any one tell me how to search with multiple scopes in fulltextsql query?
í´ve created 5 scopes and select it form a list box, but when i build the query, allways have the same answer (malformed...) with one i use this, but with more than one?? i´ve tried with ",", "OR",.. and nothing.
From Scope() WHERE "scope"=' All sites'
Thanks
Reply:
Sharepoint Search Service tool is very useful to validate/generate the search queries.
http://www.codeplex.com/SharePointSearchServ
- Edited by Poochi74 Tuesday, August 26, 2008 8:34 PM updated
------------------------------------
401.1 errors when using basic authentication and default domain of " \ "
On the Directory Security tab in the properties of our IIS site hosting our MOSS portal, we have enabled Basic Authentication, and set the default domain to \
Just like kb 827991 states, when we browse to the SharePoint site we are prompted to authenticate multiple times and then receive the "401.1 unauthorized: Access is denied due to invalid credentials" error. We can authenticate and access SharePoint fine when using just Integrated Windows authentication, but have multiple domains and where hoping to simply the log in process for our users.
Has anyone used the hotfix associated with kb 827911, http://support.microsoft.com/kb/827991, to resolve this issue in a SharePoint environment?
Thanks in advance.
Document Conversion error after converting document "file not found"
This is Moss 2007....
Word document just has text....
if you have problems injecting items into exchange from lotus, you have other options!
ok our largest vendor had email addresses with an alias field that contained text in the form [dkfj/dfkj], either the brackets were causing the failure or the forward slash was but either way we had thousands of very import messages that would not import. So I did the following and it worked perfectly.
basically you copy the mail file locally and run the following. One thing the -contentowner value can be any valid exchange recipeint. I'm sure that this technique could be used to fix other injection issues!
$allitems=Get-NotesMailArchive -DominoMailDomain 'domdomain' -ContentOwner 'Elvis.Presley@this.com -SourceFileName 't.nsf'
$fallitems=$allitems | ForEach-Object -Process { if ($_.sender -like "*EPC/TCFS`]*") { echo $_ }}
foreach ($in in $fallitems) {$in.sender = $in.Sender.FormattedAddress.Replace("`[EPC/TCFS`]","")}
$in | add-exchangeitem
ah the beauty of powershell!
please note you must have lotus and outlook installed on the device that your running this powershell script from!
Search for files modified 'today' in SP3
I installed SP3 10 days ago and when I went to look for files modified today I now seem to have to change the default 'To' date to be one day later
e.g. for today it used to be FROM August 26th TO August 26th to get all modified today and now it is FROM August 26th TO August 27th
not a big deal but maybe I inadvertantly altered a setting somewhere ??
Reply:
I cannot reproduce this problem. Searching FROM August 26 TO August 26 works for me.
What time-zone do you have your PC configured to in control panel "Date and Time", tab "Time Zone"?
------------------------------------
Reply:
Time zone was incorrect and I reset it for my location GMT+0 (London)
All OK now
cheers
------------------------------------
wss
To those who are thinking of installing WSS, before you start please make a backup of your registry, to use in case of problems,because removing WSS is very difficult .
No comments:
Post a Comment