Wednesday, March 28, 2012

restore databases 7.0

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