Viewing 15 posts - 4,741 through 4,755 (of 39,740 total)
October 11, 2018 at 7:54 am
I'd dig through any that have log larger to be sure that backups are running, verify this and audit to determine why. I've had a few with larger logs, that...
October 11, 2018 at 7:42 am
October 10, 2018 at 3:57 pm
you need to query sysobjects (and other system dbs) in that database.
as in select * from mydatbase.sys.objects.
October 10, 2018 at 3:28 pm
Here's a basic query. It produces rows, but you get the ROWs and LOG information for each database.SELECT d.name AS databasename,
f.type_desc,
SUM(size) AS totalsize
October 10, 2018 at 3:26 pm
Some of these have nothing to do with clustering or AGs.
1. What's your RPO/RTO? In other words, how much data loss and how long can you be down?...
October 10, 2018 at 3:21 pm
If you are trying to backup the database, it must be available. If you have log shipping, you cannot make a backup of a database in standby or norecovery mode....
October 10, 2018 at 3:11 pm
I wouldn't write this anymore. It's too hard to manage the data, keep the queries up to date, and it becomes a job. I would rather use a tool of...
October 10, 2018 at 3:02 pm
Definitely check IO, as Sue suggested. The system is having trouble reading drives. I'd also run DBCC CHECKDB ASAP on this database. There might be other issues. If you have...
October 10, 2018 at 3:00 pm
This whole idea of protecting PII is laughable, considering that the...
October 10, 2018 at 7:49 am
I don't quite know how this works. It was surprising to me as well. i suspect this is some strange holdever from the past, perhaps some poorly designed behavior in...
October 10, 2018 at 7:45 am
October 9, 2018 at 9:45 am
Not that I've seen. Feel free to experiment and write this one up
October 8, 2018 at 7:23 am
We are doing work on a new site now. I've asked if this is in there, but I might suggest forwarding notifications with a rule to work and leaving the...
October 8, 2018 at 7:22 am
Viewing 15 posts - 4,741 through 4,755 (of 39,740 total)