I've built a couple of queries using the existing backup history tables in MSDB:

-- Average DB size by month for ALL Databases

select a.database_name,

datepart(year,a.backup_start_date) as 'year',

datepart(month,a.backup_start_date) as 'month' ,

avg(cast((a.backup_size /1073741824) as...

Silverfox (9/2/2009)

---

off track I am afraid.

1st one does it for partitioned tables

and the others dont answer it either.

the op wants to know which file in a multiple filegroup scenario contains...

If you choose to kill a long running process, you can get an idea of how long it will take by running the KILL statement again. It will return a...

Sounds to me as though you followed the correct steps ... there's not much to it.

You're trying to run 2005 code in 2000. You might be better off posting in the 2000 forum since many here in the 2005 forum no longer have 2000.

Maybe...

"...But I can do this from SSMS:..."

Most SSMS functions can be scripted out to a query window without actually being run. Then you can see the syntax that SQL will...

sreeya (8/28/2009)

---

Hi all,

Can we restore only a single column instead of whole database?

We took backup later other teams made some changes to the database,I tried to update a column to...

Steve Jones - Editor (8/28/2009)

---

You can't calculate growth unless you know the load. The easiest way to guess this is look at the backup sizes over time. See if they...

sp_msforeachdb ?

Do you want to restore on top of the existing database ? Or restore to a new database & leave the current intact ? You can use this option...

I think one issue can be when using temp tables in Tempdb that join to tables in other databases. Since they will have different collations you may have to put...

SK (8/23/2009)

---

I have had this happen where I connect to a new session on my next login to the server. Check Terminal Services Manager and see ifyour old session...

Back in my AS/400 days, I wrote my own "Where Used - Last Used" tool to capture similar information. I could do the same thing here and put the results...

Remember that the values in sys.dm_db_index_usage_stats are reset whenever SQL is restarted, so an index that shows unused is only since the last restart.

BOL: "The counters are initialized to...

Be sure that there is no activity on the database first because they will get disconnected.