if you can do this via the alter database modify file option would be better, won't lose dbowner, dbid or possibly default database foe user.

been a while since I used...

personally I would stick the full backup just after the integrity check, then do the rest of the operations.

by the way you probably do not need to reindex every night....

Brian Fischer (11/12/2009)

---

So seeing as how the database activity is next to nil in the early morning hours. Would it be alright to take the following steps?

- set the recovery...

Brian Fischer (11/12/2009)

---

OK, so I must have been smoking something. The log file does NOT shrink when I run my maintenance jobs. Not sure what I saw earlier, but I...

fair enough 🙂

[

There is typically no activity in the wee morning hours and the full backup task occurs right after the reindex. And since there is a full backup, will the log...

I am sure I have had that error and am racking brains to remember when.............

I do think the error message bears no relation to the problem.

the fact that it works...

Steve, a lovely idea if it could be made to work.

@Kander

In this case yes I think so.........

applying a patch for a problem...

A little light reading for you 🙂

http://www.sqlservercentral.com/articles/64582/

Brian Fischer (11/11/2009)

---

Thanks for the reply. How do I keep the transaction log at 13GB when the next tlog backup I do automatically shrinks it back down to about 9MB?

Sorry,...

Brian Fischer (11/11/2009)

---

I did read about an idea that says to switch the recovery mode to bulk-logged before the rebuild and then switch back to full afterwards. Is this a...

Full backups do NOT truncate the log, and no sort of backups shrink the file.

If your log is having to grow to 13 GB to accommodate the reindex, leave it...

As you are scripting this up I presume you need to do it on a regular basis. Out of curiosity why do you have a need to regularly put your...

thanks for the tip Paul but unfortunately when I say I am the only george sibbald on the forum that is true, but the nickname george sibbald is taken, a...

Anthony, this might be more what you originally asked for:

Select o.name as 'table', i.indid,i.name as 'index',i.used * (8192.00/1024) as 'index size in KB' from sysindexes i

inner join sysobjects o on...