Restore .mdf file

[Scadhasini]

Hi

How to restore .mdf file in server database using sqlserver management studio

[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

[Scadhasini]

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

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

hi vinay,

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

[Scadhasini]

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.

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

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.

[Scadhasini]

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