Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    42

    Red face Unanswered: restore database

    I have backup of 1Gb data on 10 gb device.Can i restore it on 1.5gb device.
    also how to find size of transaction log

    Regards
    Bala

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Unfortunately you'll need a database device that is at least as large as the original database. The amount of data stored in the database is irrelevant.

    Michael

  3. #3
    Join Date
    Oct 2005
    Posts
    13

    Talking

    sp_helpdb [dbname]
    shows the size of the the layout of the db and transaction log.
    sp_helpdevice
    will display the allocated devices for the dbserv.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •