Browse by Tags
All Tags »
SQL Server (
RSS)
While the native backup in SBS backs up everything on the box, sometimes you want to be a bit more... well... paranoid about things. So one of the things you can do is script extral backups of the Line of business apps that run on SQL. Now if we had the...
I posted this the other day on a listserve and figured I should post it here as well... So you want to know if you've ran the preventative SBSmonitoring script on your server and you can't remember if you did? http://blogs.technet.com/sbs/archive...
So you want to know what version of SQL you are running on SBS 2008... run this query in your SQL management studio express... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'...
The Official SBS Blog : Requirements for Installing SQL 2008 Standard Edition for Small Business: http://blogs.technet.com/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx To follow up on this post,...
Top issues from the managed newsgroup Partner Online Technical Support Communities Newsgroups: https://partner.microsoft.com/US/40014662 In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT...
In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- After you added a SQL Server 2008 to 2005 cluster, you encountered the following errors: 1...
Part two of debugging SQL server issues.... from the Partner managed newsgroups. (There's good stuff in there) (II) *Internal Physical memory pressure: SQL Server detects high memory consumption internally, causing redistribution of memory between...
From the Partner managed newsgroup: This section specifically addresses low memory conditions and ways to diagnose them as well as different memory errors, possible reasons for them, and ways to troubleshoot. Background It is quite common to refer to...
Aaron Bertrand : SQL Server 2008 Cumulative Update 1 is available: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/09/23/sql-server-2008-cumulative-update-1-is-available.aspx They just RTM'd SQL 2008 and already there's an update. And ya...
In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- When you tied to install security update 948109, you encountered the following error: Product...
MSDE a memory hog..... Who da thunk... not me .... Dear Susan Bradley, After extensive research and monitoring, it has been determined that the resource used by SQL express engine causes a dramatic performance decrease for the server. Futhermore, it creates...
http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=4&y=8 SQL 2000 falls out of mainstream support in April of 2008. If your line of business vendor is still only supporting SQL 2000, sit them down and have a talk with them. Ask them...
The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released: http://support.microsoft.com/kb/937137/LN/ I have no idea what build number I have of SQL 2005 to be honest with you...but I'm losing track of 'em...
How to downgrade to SQL Server 2000 on a computer that is running Windows SBS 2003 R2 Premium Edition: http://support.microsoft.com/?kbid=935573 Buried in yesterday's KB listing was that gem. Okay read it again.... you know what it means? I'll...
http://msmvps.com/blogs/bradley/archive/2007/08/11/detach-and-reattach.aspx So Chad informs me that all that SQL command line stuff I was so proud of could have been all done via the GUI 'sure nuff. Detach and reattach via the GUI.... Now he tells...
So you need to move a SQL database 'eh? First off the trick is to "get" to that database with a management tool http://msmvps.com/blogs/bradley/archive/2007/06/12/connecting-to-the-wsus-database-with-sql-2005-s-tools.aspx If you don't...
When I go to check the mg_EmailQueue table it gives off an error and tells me to run DBCC CHECKTABLE. I am such a SQL newbie dweeb it's not funny... okay so reading this... http://msdn2.microsoft.com/en-us/library/ms174338.aspx What do I put as view...
I'm not a command line gal and I wanted to document that in order to use the SQL management studio included in SQL 2005 workgroup/R2 to do this , doing this didn't work. Instead as the comment said in the prior blog post, I have to use a pipe...
FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005: http://support.microsoft.com/default.aspx?scid=kb;en-us;934396 Okay that's a slightly weird hotfix When I get a hotfix...
If you are running SBS standard and you want to control the SQL that comes with WSUS 3.0 the EXACT tool you need can be obtained from THIS link: http://go.microsoft.com/fwlink/?LinkId=65110 (Image courtesy of Handy Andy Goodman as I still haven't...
More Posts
Next page »