Post reply

Restore

  • March 25, 2009 at 8:47 am

    #95288

    Hi,

    Can i restore a backup of database to 'tempdb'?

  • March 25, 2009 at 8:55 am

    #966023

    no, but why would you want to do this?

  • March 25, 2009 at 9:40 am

    #966060

    weired. why you want to restore tempdb. was you put critical user data in it???

    :crazy: :alien:

    Umar Iqbal

  • March 25, 2009 at 9:59 am

    #966071

    Hi,

    TempDB is, as the name suggests, for temporary data - temporary tables you may have created in T-SQL, temporary tables that SQL itself decides it needs and such exciting things.

    Certainly in 2005 it re-created whenever SS starts and I can't imagine it is any different in earlier versions, so therefore it cannot be backed up or restored.

    Generally you will just leave it alone.

    Steve Hall
    Linkedin
    Blog Site

  • March 25, 2009 at 11:59 am

    #966172

    umar iqbal (3/25/2009)

    weired. why you want to restore tempdb. was you put critical user data in it???

    Umar, he wants to restore a database to tempdb.

    Why you want to do this?:w00t: It overwrites all the existing data on the tempdb database which might be used by your applications.

Viewing 5 posts - 1 through 4 (of 4 total)

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