Tuesday, February 21, 2012

Restore .mdf file

Hi

How to restore .mdf file in server database using sqlserver management studiocreate 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|||

Quote:

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|||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...

Quote:

Originally Posted by Scadhasini

hi vinay,

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

|||

Quote:

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.|||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 ..

Quote:

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.

|||

Quote:

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

No comments:

Post a Comment