GilaMonster (9/16/2010)

---

Index rebuilds?

Yes. The log can only be truncated up til the beginning of...

When you specify that it should delete .BAK files, do not inlude the "." (dot, or period) in the extension .... just BAK

Welcome to SQL 2005 🙂

Why are you doing a shrink database ? There are many posts on this site about the problems you will cause to your indexes by doing a DB shrink.

...

1) Find & delete...

Search...

Choose "Results to Text", then copy/paste the results into a new window.

declare @OldOwner varchar(100), @NewOwner varchar(100)

set @OldOwner = 'oldowner'

set @NewOwner = 'dbo'

select 'sp_changeobjectowner ''[' + table_schema + '].[' +...

I build manual scripts to rebuild/reorg indexes. For the larger ones, I do a t-log backup in between to keep log size manageable.

Why do you need to maintain your indexes so frequently ? I usually do ours every couple of months on the busy databases.

However, I do log backups about every...

What do you mean by "bare-metal recovery" ?

tt-615680 (9/14/2010)

---

Hi All,

I set a job to run every morning, for the first few days it worked fine but from yesterday morning, when I run the query that checks if...

When I want to modify the system SP, I make a new version, with my own naming convention so as not to be confused with the systm version.

Go to the "Notifications" section of the job, and the email options are there.

At first glance it looks ok. No reason you can't just try it and see.

As a habit, once you have installed SQL, you should set up a job to backup the system databases, and then add backups for any other databases that get created...