Viewing 15 posts - 1,186 through 1,200 (of 2,496 total)
I would also advise you detach all your user databases before you do the upgrade, and attach them after you are happy the upgrade is successful.
If your upgrade fails and...
September 30, 2009 at 6:57 am
I work for a job search company called Totaljobs. I can tell you that we use SQL Server Full Text search as part of the way we match jobs...
September 30, 2009 at 3:16 am
Duplicate post. Please post all answers to http://www.sqlservercentral.com/Forums/Topic794373-338-1.aspx
September 30, 2009 at 3:08 am
There may be a lack of trust between the two machines. Dealing with trusts has changed a lot with W2008.
Try adding the target server to your Trusted Sites in...
September 30, 2009 at 3:03 am
SQL Server takes a shared schema lock when a backup is taken. This prevents the database from being dropped while the backup is running, but does not prevent any...
September 30, 2009 at 2:39 am
You say the server has 128 GB memory installed and you have set SQL max memory to 120 GB. You are probably asking for more memory than is available.
When...
September 29, 2009 at 3:15 am
Are you running 32-bit or 64-bit?
On 32-bit servers you have limited memory available to run things such as backups. This memory is also shared with other tasks, such as...
September 29, 2009 at 2:53 am
Disk fragmentation as seen by Windows is nowadays very rarely the disk fragmentation seen by the disk controller.
Some SANs have the concept that a LUN is a contiguous chunk of...
September 28, 2009 at 3:01 am
Microsoft say that mssqlsystemresource must be in the same folder as master for SQL 2005.
If they are in different folders and you apply SP1, then the SP1 install...
September 28, 2009 at 2:47 am
If testing restores in multiple scenarios shows
if one can do the recovery 100% of the time and the other can only recover 95% of the time
then you...
September 25, 2009 at 8:03 am
Jacob is right. I was going to post much the same, but he got there first.
September 25, 2009 at 6:42 am
It is important to move away from a turf war about who should do what, and focus on the business objectives.
Most businesses will have recovery objectives and SLAs. These...
September 25, 2009 at 6:39 am
If your ETL processing is just one query among many others on the same SQL instance, you cannot restrict it to using a single CPU.
The best you can...
September 25, 2009 at 6:16 am
IMHO if you have a disk dedicated to backups you do not need to worry about fragmentation on this drive. Because backup files get created and deleted on a...
September 25, 2009 at 6:07 am
You should consider using an anonymous account for the xp_cmdshell proxy account.
This proxy is used by all non-sysadmin users who want to run xp_cmdshell. The proxy will need access...
September 24, 2009 at 3:54 am
Viewing 15 posts - 1,186 through 1,200 (of 2,496 total)