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 |
|
disorder
Starting Member
4 Posts |
 Posted - 2002-01-31 : 05:51:27
|
| Hi, I have recently developed a web app using access with Asp. Due to requirements, we have decided to move to SQL server. I have succesfully imported the structure etc. and tested on my local development test server running SQL Server 2000 . It works fine here, i now want to test the site with a bit of data for performance and to iron out all bugs over the net. i have tried to move the database to our web server by detach/attach method.When i try to attach on the web server i get the following error: ----Attaching DatabaseServer: Msg 5172, Level 16, State 15, Line 1The header for file 'c:\data\sahara\saharatemp.mdf' is not a valid database file header. The PageAudit property is incorrect.-------Our local server runs SQL Server 2000 and the web server runs SQL Server 7 *please note this is the first time im working with sql server |
|
|
bcollinson
Starting Member
9 Posts |
Posted - 2002-01-31 : 07:30:34
|
You're trying to import into a previous version of SQL Server, and there's some incompatibilities.Why not use the enterprise manager and 'Generate SQL Script', making sure 'Only script 7.0 compatible features' is ticked - load the generated file into query analyser and execute it.I'd be very careful, testing on a production server ...quote:
Hi, I have recently developed a web app using access with Asp. Due to requirements, we have decided to move to SQL server. I have succesfully imported the structure etc. and tested on my local development test server running SQL Server 2000 . It works fine here, i now want to test the site with a bit of data for performance and to iron out all bugs over the net. i have tried to move the database to our web server by detach/attach method.When i try to attach on the web server i get the following error: ----Attaching DatabaseServer: Msg 5172, Level 16, State 15, Line 1The header for file 'c:\data\sahara\saharatemp.mdf' is not a valid database file header. The PageAudit property is incorrect.-------Our local server runs SQL Server 2000 and the web server runs SQL Server 7 *please note this is the first time im working with sql server
|
 |
|
|
|
|
|
|
|
Help Moving DB