Viewing 15 posts - 31,501 through 31,515 (of 39,821 total)
Johan,
Whether you are correct or not, it would be nice to acknowledge those lost.
I was hoping we're have more discussion on data centers and unexpected issues rather than anything...
September 11, 2007 at 8:50 am
While I'm sure there are cases where this applies, it could easily be abused as well. The US is a little sue-happy at times and I'm not sure this should...
September 10, 2007 at 1:50 pm
It's good to see people that believe this is as horrible as I think. There's definitely blame to go around as passwords should have been changed ASAP when someone in...
September 10, 2007 at 1:38 pm
I was hoping for some good SQL Server comments, but maybe we just like picking on Oracle ![]()
How about these:
I love that SQL Server...
September 10, 2007 at 8:57 am
If this is just a modification, you might want to submit it as a script.
September 10, 2007 at 8:45 am
Bob is correct. The word from MS engineers is don't shrink the DB. Shrink the log if needed, but not the db. Can mess up indexing efficiency (in terms of...
September 10, 2007 at 8:42 am
sysadmins alias to dbo.
Remove the builtin_admins from the sysadmin group.
September 10, 2007 at 8:40 am
You get the value from the "INSERTED" trigger. Meaning something like this:
create trigger ...
for update
as
update audit_table
set val = i.val
from inserted i
where i.table_id = audit_table.table_id
September 10, 2007 at 8:39 am
There have been great suggestions in this thread, but I'd submit that your hardware is likely very underpowered for this setup. If you really have that many connections, you need...
September 10, 2007 at 8:32 am
Are you restoring a new db on both servers? Or an existing one on the old server? Also, are these from local disk for the backup file?
Does seem a little...
September 10, 2007 at 8:20 am
I'd agree with Jeff on that one. It gives you real world situations and problems that you have to solve.
Getting a book and working through it will help as well....
September 10, 2007 at 8:19 am
I don't have a complete list, but here's some reading on the topic.
http://www.sqlservercentral.com/columnists/sjones/worstpracticedetaileddisasterplans.asp
http://www.sqlservercentral.com/columnists/sjones/2744.asp
http://www.sqlservercentral.com/columnists/sjones/incidentresponserespondingtoanincident.asp
You'll never keep up with specific plans. The important things are to practice restores, so you have confidence...
September 10, 2007 at 7:59 am
I don't think you can do this. The database needs to finish recovering.
Do you know if it's in roll forward or roll back? Check the error log.
September 10, 2007 at 7:56 am
Stephanie,
While I agree that someone should have noticed backups failing, I can see the problem there. How does a network admin check the backups?
he looks for failures. You'd need some...
September 10, 2007 at 7:35 am
That's a great song. Remember hearing it for the first time, 1987, driving to UVa after summer vacation.
September 7, 2007 at 8:27 pm
Viewing 15 posts - 31,501 through 31,515 (of 39,821 total)