backup size and initial database size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db - 11 Mar 2008 16:14 GMT

SQL server 2000

Hi

How can i find

1. Information about all/current backup files, size of backup file on
server using sql query or a script.

2. Initial size of all databases (when they were installed) and current size
of all databases.

Thanks

Signature

ontario, canada

Reply to this Message

db - 11 Mar 2008 17:07 GMT

I have information about all database backups for last two years (Including
database size in table Backupset in MSDB.

Does % increase in database backup size reflects the % increase in database
size??

Signature

ontario, canada

> SQL server 2000
> Hi
[quoted text clipped - 5 lines]
> Thanks
> ontario, canada

Reply to this Message

db - 11 Mar 2008 17:54 GMT

I am using

select database_name,database_creation_date,backup_start_date,backup_size
from backupset order by database_name,backup_size desc

to get the bacup size information. I get the information.
I want to select a subset of records which give me information for backupset
for one day of every month (10-???-200?). I.e monthwise backup set
information for 10-jan, 10-feb-10-mar....etc). When I issue FOLLOWING COMMAND

select database_name,database_creation_date,backup_start_date,backup_size
from backupset WHERE BACKUP_START_DATE LIKE '10-???-200?) order by
database_name,backup_size desc

I do not get the desired result. What is correct sql query?

Signature

ontario, canada

> I have information about all database backups for last two years (Including
> database size in table Backupset in MSDB.
[quoted text clipped - 11 lines]
> > Thanks
> > ontario, canada

Reply to this Message

Tom Cooper - 11 Mar 2008 19:05 GMT

Select ...
Where BACKUP_START_DATE >= '20000101' And Day(BACKUP_START_DATE) = 10

Tom

>I am using
>
[quoted text clipped - 32 lines]
>> > Thanks
>> > ontario, canada

Reply to this Message