Viewing 15 posts - 36,196 through 36,210 (of 39,717 total)
The maintenance plan itself must be created, not just the jobs. PITA, and I'm sure there's a way to script out the plan, but I haven't bothered. They are pretty...
June 13, 2003 at 9:55 am
I don't ever see the *.ckp files in my backup folder. Checkpointing is an operation that writes out the transaction logs automatically and ensures data is on disk.
Steve Jones
June 13, 2003 at 9:51 am
Daily - Backups
Weekly - Integrity (dbcc), Patch application and testing.
Monthly - Baselining
Steve Jones
June 13, 2003 at 9:35 am
Don't use "select *", list out the columns you need. And only those columns.
Use ANSI syntax, makes things clearer, ex:
select a.colA, b.colB
from tableA a
...
June 13, 2003 at 9:33 am
sa might be mapped to a user. The login would be sa, the user something else.
select
u.name
, s.name
from sysusers u
inner join master.dbo.syslogins s
on u.sid = s.sid
Steve Jones
June 13, 2003 at 9:29 am
Very nice scripts. Need some modifications for me, but these are handy to have around.
Steve Jones
June 13, 2003 at 9:27 am
Which part of the maintenance plan? I suspect that either the plan didn't create correctly or there is corruption in sqlmaint.exe.
Have you dropped and recreated the plan? Can you create...
June 12, 2003 at 4:19 pm
June 12, 2003 at 4:17 pm
June 12, 2003 at 4:08 pm
Be sure the sql server is running. Also are you using NT authentication or mixed?
Steve Jones
June 12, 2003 at 10:50 am
We standardize on RAID 1 for OS, RAID 1 for logs, RAID 5 for data. Sometimes split that further. For one high end DSS system we went with RAID 10...
June 12, 2003 at 10:47 am
Use DTS to transfer the logins after that. Sp_change_users_login to synch users/logins if you need to.
Steve Jones
June 12, 2003 at 10:41 am
Your company should have some policy spelled out, probably for email, that all activities may be monitored, blah, blah, blah. I suspec that this would cover profiler.
Of course, IANAL.
Steve Jones
June 12, 2003 at 10:31 am
srvinfo gets a bunch of stuff, but takes some parsing.
Steve Jones
June 12, 2003 at 10:16 am
As an aside, if you've run on SS2K/ W2K for a year, you are missing some valuable security patches. Not that you have to apply them, look at your...
June 12, 2003 at 10:15 am
Viewing 15 posts - 36,196 through 36,210 (of 39,717 total)