To maintain the ownership chain - you need to have those schemas owned by the same user. If both schemas are owned by dbo, you shouldn't have any problems...

If you are using a maintenance plan - which is an SSIS package, it is possible that it is running through integration services.

I think it depends on what version level...

Whether or not you need 8 files - you should not set the auto-growth to a percentage. And, just because you have 2 TB of space available - does...

andrew.hopkinson (11/22/2010)

---

thank you for this! It seems to be that this was not necessary in pre R2 installations of SQL Server 2008. BTW, I also had to restart my SQL...

As has been stated multiple times - this means the service account running SQL Server is not set to a domain account. Not sure what else to tell you...

Nothing will happen to your data or tables - they are already upgraded to 2005 regardless of the compatibility level.

The only thing that will happen is that deprecated commands that...

Is the pathing setup correctly for the new LUN?

Shawn Melton (11/19/2010)

---

IMHO: You can never have to many backups when you do major maintenance on your database. As long as you know those backups are tested and ready to...

I would have to say that is a bit much - and you don't need to backup the database twice.

Now, as to whether you do the backup before or after...

Yeah, that could do it - or any other processes accessing the files when you try to delete them. Hopefully that will solve the problem.

As Gus stated - not in the same database. Why would you want a synonym to be the same name as an existing object?

What problem are you trying to...

Beth,

One of the things about maintenance plans is that they are not agent jobs. They are in fact SSIS packages that are run from an agent job. What...

A better method would be to convert the comma-delimited column into a table and join on the table.

You can search this site for many examples of how this can be...

bethrich (11/18/2010)

---

I'm pretty much stuck with maintenance plans since I'm the only DBA in the shop and backed up by non-DBAs. In SQL 2008 SP1 (not R2), running in VM...

nathan 7372 (11/18/2010)

---

Ok, I changed the job ownership to sa. I had just left the ownership as the domain administrator because that was what my predecessor did and I...