GabyYYZ (4/27/2010)

---

1. Security: working on it...

2. Processes: what's a process? 😀 (yeah I know, this is forcing us to think)

3. Roles: probably the easiest piece so far we're dealing...

If these are important databases with frequent activity, then it's strange you are only taking transaction log backups once a day at 3:30 am. If you have a failure...

OP's DBA was "helping", but not sure that it was...

Ideally, you would leave the free space there so it's available as your database grows. Then it does not need to re-allocate the space. If you absolutely need the space...

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The...

There are probably no backups, so it may not matter how the t-log is shrunk.

So ... you would advise against creating a nightly...

Did you take a full backup after switching back to full recovery ?

We posted 2 pages the other day trying to help you with this problem. Instead of starting a new thread, you could read the replies, answer the questions, and read...

Idera also has a more straight forward Object Level Recovery. We use Redgate here because it was in place before I started, otherwise I'd lean towards Idera that I...

You could create an insert trigger that puts the value NAME into another table. It would overwrite whatever the previous value was with the new value. Or add a...

striker-baba (4/23/2010)

---

Thanks to all for the replies.

I ran the query

SELECT

a.index_id,

name,

avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(' dbname '),OBJECT_ID(' table a '),NULL, NULL, 'limited') AS a

JOIN sys.indexes AS b ON

a.object_id...

striker-baba (4/25/2010)

---

Actually , I first tried to shrink the log and data file using dbcc shrinkfile command.

But after using the command both the data and log file sizes got increased.

I...

striker-baba (4/25/2010)

---

I had a suggestion to put the database in simple recovery mode and then shrink the transaction log file

I dont know what impact does it has on the...

Assuming it's a production database, do you understand the disaster recover risks of switching to simple ?