Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing a .bak database into sql
- Thread starter mp11
- Start date
tlbroadbent
MIS
Is the file a backup made in SQL 7? If it is, then you need to restore the database. See RESTORE in SQL BOL or use Enterprise Manager.
If it is not a SQL 7 backup, what kind of file is it? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
You can restored a backup file in different way,
1. RESTORE (T-SQL query)
2. With Interface, with the Enterprise Manager, right-click on the database and choose All Tasks, choose Restored Database and choose Device, Add the file into the Device and click OK.
The only constraint is that it must be a backup file from SQL Server 7. If it is SQL Server 6.5, the approach is different.
Kim
1. RESTORE (T-SQL query)
2. With Interface, with the Enterprise Manager, right-click on the database and choose All Tasks, choose Restored Database and choose Device, Add the file into the Device and click OK.
The only constraint is that it must be a backup file from SQL Server 7. If it is SQL Server 6.5, the approach is different.
Kim
- Status
Similar threads
- Locked
- Question
