Restore .mdf file

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Scadhasini
    New Member
    • Dec 2006
    • 21
    #1

    Restore .mdf file

    Hi

    How to restore .mdf file in server database using sqlserver management studio
    Tags: None
    • vinaykeshav
      New Member
      • Dec 2006
      • 25
      #2
      create a dummy db under ur db server and then on right click u have the
      option to restore the database.. using this u can achieve this

        Comment

        • Scadhasini
          New Member
          • Dec 2006
          • 21
          #3
          Originally posted by vinaykeshav
          create a dummy db under ur db server and then on right click u have the
          option to restore the database.. using this u can achieve this

          hi vinay,

          i am doing same way. buts its saying that ,its not a valid Microsoft tape format backup set

            Comment

            • vinaykeshav
              New Member
              • Dec 2006
              • 25
              #4
              our .mdf file may b corrupted..
              first tk a backup of some other db and while restoring make sure the name of the db is same...

              Originally posted by Scadhasini
              hi vinay,

              i am doing same way. buts its saying that ,its not a valid Microsoft tape format backup set

                Comment

                • Scadhasini
                  New Member
                  • Dec 2006
                  • 21
                  #5
                  Originally posted by vinaykeshav
                  our .mdf file may b corrupted..
                  first tk a backup of some other db and while restoring make sure the name of the db is same...


                  its working all db's . but i am trying to restore .mdf file. i am working with dnn4.while creating dnn web application i installed db in Database.mdf file.
                  now i am trying copy this in to server db.but is not working.

                    Comment

                    • vinaykeshav
                      New Member
                      • Dec 2006
                      • 25
                      #6
                      In SQL Query Analyzer, back up a database by running the following command:
                      BACKUP DATABASE DatabaseName TO TAPE = TapeDriveName WITH FORMAT, BLOCKSIZE=65536 , NOUNLOAD
                      Notes• This command formats the tape with a block size of 64 KB. Therefore, the tape can be used by SQL Server 2000 and Windows Server 2003.

                      try to backup using above cmd and try restoring ..

                      Originally posted by Scadhasini
                      its working all db's . but i am trying to restore .mdf file. i am working with dnn4.while creating dnn web application i installed db in Database.mdf file.
                      now i am trying copy this in to server db.but is not working.

                        Comment

                        • Scadhasini
                          New Member
                          • Dec 2006
                          • 21
                          #7
                          Originally posted by vinaykeshav
                          In SQL Query Analyzer, back up a database by running the following command:
                          BACKUP DATABASE DatabaseName TO TAPE = TapeDriveName WITH FORMAT, BLOCKSIZE=65536 , NOUNLOAD
                          Notes• This command formats the tape with a block size of 64 KB. Therefore, the tape can be used by SQL Server 2000 and Windows Server 2003.

                          try to backup using above cmd and try restoring ..

                          I am working with sqlserver 2005 and windowsXP.i dont have sqlserver2000

                            Comment

                            Previous template Next
                            Working...