Viewing 12 posts - 106 through 118 (of 118 total)
You're right Colin, the admin course is a good place to start. I took a 5-day SQL course (MS Course 2780B, Maintaining a Microsoft SQL Server 2005 Database) and coupled...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 1:40 pm
horace (1/8/2008)
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 1:26 pm
You can right click on the Job that runs the backup and go to properties. On the left hand side choose Notifications. There you can set SQL server to email...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 11:20 am
Here's a good article with recommendations you may want to look at:
http://www.sql-server-performance.com/articles/dba/self_taught_dba_p1.aspx
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 6:47 am
Ah ok I think I'm understanding you a bit now. My personal take on that situation is if CU3 addresses your problem and the current release is CU4 then I'd...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 6:41 am
I typically wait for full service packs before I move to production unless there really is a pressing need to apply a CU. If you have the resources you could...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 8, 2008 at 5:56 am
Why don't you use SQL mail for your 2000 instance and DB Mail for your 2005 instance?
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 7, 2008 at 10:49 am
This sounds like a job for...duh duh duh dah...SCHEMAS! Check your SBO for schemas [SQL Server] and read up a bit on schemas and how to create/manage them. To me...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 7, 2008 at 9:47 am
Roy Ernest (1/3/2008)
We have been experimenting with VMWare on our QA. I cannot give any good feedbacks on it.The performance kinda sucks. (Atleast in our set up)
Just out of...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 7, 2008 at 7:58 am
SQL 2005 gives you a wide range of options for setting up custom alerts, including Windows errors (I believe). If you right-click Alerts and setup a new alert, under the...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 7, 2008 at 7:54 am
What database are you querying off of? Try this:
Use master
EXEC sp_validatelogins
GO
Also this command only gives you logins that no longer exist but still have access to the instance. I'll check...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 4, 2008 at 7:22 am
I had this similar issue but found the solution (at least for me anyhow). For an install of Virtual Center I temporarily had to make another account the dbo on...
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 4, 2008 at 7:16 am
Viewing 12 posts - 106 through 118 (of 118 total)