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