Viewing 15 posts - 1,516 through 1,530 (of 2,496 total)
A SharePoint database is just a database. You need to do all the normal maintenance that is needed on any database.
The KB article mentioned above confirms that...
January 27, 2009 at 2:52 am
There are three things to consider with this. You should read what Books Online (BOL) has to say about all of these, as well as the posts in...
January 26, 2009 at 3:07 am
It is important that you setup the database to automatically shrink itself.
This is BAD advice. You should never shrink your database on a regular basis. If you do:
1)...
January 26, 2009 at 2:42 am
This sounds like you only have the client tools media in your install folder. Alternatively, if both the server and tools media were copied to the same folder then...
January 23, 2009 at 2:27 am
Using detach and attach for user databases is a good idea. Even if you do an upgrade in place it is good to detach the user databases before you...
January 22, 2009 at 2:56 am
If your server is 32-bit, make sure you have AWE enabled. If you are not sure how to do this, look in Books Online (BOL).
If you are running 64-bit...
January 21, 2009 at 4:02 am
Good practice for doing upgrades in a Production environment is to take an image of the relevant disks before starting the upgrade. That way if the upgrade fails you...
January 21, 2009 at 3:57 am
I noticed in the OP that you only had SQL 2005 Tools installed.
SQL 2005 install media is delivered on 2 CDs, one for server components and one just for the...
January 21, 2009 at 3:51 am
There can be lots of rubbish stored on ther system drive that can be deleted. As a start, look in:
Windows /Temp folder
Each user's /Temp folder (in their user profile)
Each...
January 21, 2009 at 3:40 am
All things are possible, but not all things are beneficial
Paul, early ADs
It may be possible to move the system databases, but for most of them it is not beneficial....
January 19, 2009 at 5:36 am
For me, the issue to the airport operator being at the mercy of what the government provides in terms of staff is a cop-out. The airport is an entrepot...
January 19, 2009 at 5:18 am
SQL Server FineBuild has a load of scripts you can use for this export and import. Feel free to raid the code for anything you need.
January 19, 2009 at 5:06 am
I like being in different places, but I feel the increasing hassle of getting there is a big discouragement.
For me, airports offer about the worst customer service on the planet....
January 19, 2009 at 4:17 am
tosscrosby (1/8/2009)
why use the -g switch as opposed to simply setting a lower fixed amount for SQL within EM?
Having put my brain into gear, reducing SQL max memory is the...
January 9, 2009 at 2:28 am
The default for -g in SQL Server 2000 is 256 MB (See Using Startup Options in BOL). What I did was increase this by 64 MB until the system...
January 8, 2009 at 2:41 am
Viewing 15 posts - 1,516 through 1,530 (of 2,496 total)