how do i convert sql server 2000 database to sql server
7.0 database, i have the mdf and ldf files of 2000
database, but i get an error when i use sp_attach_db, can
anyone help me out on this...
Thanks in advance
Aravind
by Aravin » Wed, 27 Mar 2002 14:21:31
Thanks in advance
Aravind
by Sue Hoegemeie » Wed, 27 Mar 2002 14:45:36
--Sue
On Mon, 25 Mar 2002 21:21:31 -0800, "Aravind"
>Thanks in advance
>Aravind
1. importing a SQL Server 7.0 database to a SQL Server 7.0 database
Hi All,
I am new to SQL Server and Windows in general. I was given what is
supposed to be a SQL Server 7.0 database on a cd. The only file on the
cd is named databasename.db. I have read and reread the BOL and the
SAM SQL Server book and I can't find a reference to a .db file type
nor can I get SQL Server to import the file. I don't think that it was
a bulk copy or a bcp. I also don't have the option of asking the
file's creator since he is no longer available. So am I missing
something basic or is the file junk. Any help will be appreciated.
2. ORA-30002
3. Copying database from SQL server 2000 to remote SQL server 7.0
4. Backup/Restore a 10MB Dabase on multifloppies
5. Restoring SQL Server 7.0 database to SQL Server 2000 Environment Question
6. Database Product Selection ???
7. Importing SQL Server 7.0 database to SQL Server 2000
8. VA-DBA
9. Migrating an SQL Server 7.0 database to an SQL Server 2000
10. Copying database from SQL server 2000 to remote SQL server 7.0
11. Upgrading SQL Server 7.0 to SQL Server 2000 - Meta Data Repository Database Version Problem
12. Restore database from SQL Server 2000 to SQL Server 7.0
13. Restoring msdb database from SQL Server 7.0 backup to SQL Server 2000