Post reply

Original size of DB

  • July 31, 2006 at 9:28 am

    #173655

    Hi there,

    Is there a way of finding the original filesizes of DB- and Log-file on creation of the database?

    TIA

    Greetz,
    Hans Brouwer

  • July 31, 2006 at 9:33 am

    #652408

    If you look in sysaltfiles within the master database check the size * 8/1024 for the size in MB.

    It certainly works for TEMPDB however, if your database was built without specifying a size then have a look at the MODEL database as your DB will have started out as an exact copy of that database.

    LinkedIn Profile

  • August 1, 2006 at 12:57 am

    #652518

    Tnx for answering, David. One learns everyday.

    Greetz,
    Hans Brouwer

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply