469,097 Members | 1,388 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

Restore .mdf file

Hi

How to restore .mdf file in server database using sqlserver management studio
Dec 15 '06 #1
6 14595
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
Dec 15 '06 #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

hi vinay,

i am doing same way. buts its saying that ,its not a valid Microsoft tape format backup set
Dec 15 '06 #3
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
Dec 15 '06 #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...


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.
Dec 15 '06 #5
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.
Dec 15 '06 #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 ..

I am working with sqlserver 2005 and windowsXP.i dont have sqlserver2000
Dec 15 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by butatista | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.