Viewing 15 posts - 36,376 through 36,390 (of 39,903 total)
Might be. Perhaps there is some temporary file there. Can you move the location for backup files and then restart?
Steve Jones
June 13, 2003 at 10:44 am
IANAL - I am not a lawyer.
I searched out our security people and they said that the info sec policy that we agree to says that you do not have...
June 13, 2003 at 10:15 am
great advice above. One more I'd add - SQL Litespeed. Works great and has reduced our largest backup substantially in size and time. Went from 60G native to 9GB...
June 13, 2003 at 10:12 am
I'd use a view as well. Use separate dbs if they need to maniuplate the data separate from other users.
Steve Jones
June 13, 2003 at 10:08 am
Sorry haven't read it. Can you post your thoughts or write a review? We'd love to have it on the site. Send a review in email to me (sjones@sqlservercentral.com) if...
June 13, 2003 at 10:05 am
Remove guest from msdb and do not give him access to this database.
Steve Jones
June 13, 2003 at 10:00 am
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
Viewing 15 posts - 36,376 through 36,390 (of 39,903 total)