I have taken backups of 3 datbases
as
man1.dbf
msdb,model databases on drive d: but not taken master datbases then i had to format the c: on which sql server installed.
can i take full restore in this case or i have to create datbases and then sp_attach and sp_detach databases pls help me.
Some more details would be helpful:
1) what version of SQL Server is involved? Is it 7.0 or other?
2) What command was used to produce the backup files?
That will help us figure out the best course.
|||how have u taken the backup. Is it using Backup Database command or using SP_Detach_db to detach the db and then backup the mdf and ldf files. If you have used detach method you can use sp_attach_db to attach the database. If you have used Backup database command then you need to use Restore database command probably with MOVE Option.
Madhu
No comments:
Post a Comment