if you are looking to consolidate your servers then a good pointer is the amount if IO activity per database so use dmv sys.dm_io_virtual_file_stats to track those values.

It's a no...

This I believe is the code based way to delete maint plan after a msdb move. Never tried it myself as I tend to avoid copying system databases around.

-- steps...

are these maintenance plan jobs? these are created as SSIS packages and the server name is hardcoded within them. You will have to delete the plans and recreate them. (via...

Just to clarify in SQL2000 it is called 'Index tuning wizard' rather than database tuning advisor

Steve Jones - SSC Editor (1/7/2011)

---

Mrs. Tripp recommends 512MB segments, so growth around 8GB at a time.

I would guess that depending on your volume, you might get better/worse performance with...

Tom.Thomson (1/7/2011)

---

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by...

for restores you need to use table msdb..restorehistory

--returns info on when databases were restored and from which backup file

SELECT [rs].[destination_database_name],

[rs].[restore_date],

[bs].[backup_start_date],

[bs].[backup_finish_date],

[bs].[database_name] as [source_database_name],

[bmf].[physical_device_name] as [backup_file_used_for_restore]

FROM msdb..restorehistory...

OS error 5 means 'access denied'. You have a permissions problem

If you want those databases to be updateable why not just automate the overnight restore, or perhaps use snapshot replication.

If the databases only need to be readable then you could...

Janie.Carlisle (1/5/2011)

---

hmmm I actually like the idea of turning off autogrowth and forcing the new data to the new filegroup. I think I will do that. It doesn't solve the...

no its not scary, just research files and filegroups (start with books on line) and make sure you take a database backup before you start.

If you want to keep it...

you cannot explicitly move a specific object between files in the same filegroup, but you could add another file to the filegroup and data would begin to be written to...

you will be able to restore a user database between these versions. As long as both are SQL2008R2 (which there are as 10.50.xxxx).

edited to clarify my meaning in second sentence

I second Avatar, but it must be in HD, stunning visual quality. good story as well.

http://msdn.microsoft.com/en-us/library/ms189573(v=sql.90).aspx