Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-15 : 08:45:03
|
| venkatsathish writes "Hi, How do I attach my .MDF file and .LDF files to the database in MS SQL Server 7.0 version. I was able to do this in MS SQL Server 2000 Std. Edition, but i am not able to do the same with MS SQL Server 7.0.Anybody who knows abot this, pl help me out of this.Venkatsathish" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-15 : 09:57:22
|
| Instead of doing it via Enterprise Manager, use sp_attach_db from Query Analyzer (see BOL for syntax)---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-15 : 21:07:17
|
| I think that if these were in full SQL 8.0 compatibility mode (i.e. fully SQL 2000 converted) that you may not be able to attach them to a SQL 7.0 server. At least I know that you can't RESTORE a SQL 2000 backup to a SQL 7.0 server, I'm guessing it is the same with Attach/Detach.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Attaching DB file