MS SQL SERVER -restore database from .dat file

hi
how to retore a database from a .dat file..
and how to retore a single table from a database.
chandu_kappaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
shirazcConnect With a Mentor Commented:
If using sql 6.x

1.Put the dat file in \mssql\backup folder
2. create a backup device from enterprise manager at same path, with primary name of dat
3.click refresh for backup devices

4. go to database and right click, go to backup/restore

5. go to restore tab, choose devices

6. choose device having name as your dat.
7. click on option button "single table"
and choose table abd click restore

this should do for sql 6.0 and 6.5

you can't restore a table in 7.0

regards

shiraz
0
 
crsankarCommented:
Which version of sql server are you using? SQL Server 7.0 does not support restore of a single table if I am not mistaken. As far as restoring form a datafile is concerned the syntax is

RESTORE DATABASE MyNwind
FROM DISK = 'c:\mssql7\backup\MyNwind.bak'
0
All Courses

From novice to tech pro — start learning today.