February 8, 2008 at 7:20 am
Hello
New to sql and learning the hard way.
we had our 2005 sql go down so in order to get it up we have a 2000 sql server going.
1. I restore a 2005 backup to the a 2005 develop version
2. Restore an older 2000 backup onto the 2000 server. (we had moved the database from 2000 to 2005 back in august).
3. deleted all data from the tables in the 2000 sql database.
4. I exported all the data from table in the 2005 sql database to excel.
5. I imported all the data to the empty tables in the sql 2000 database.
Now when the program that the user use to reigister people for seminars they get the error 94 invalid use of naull value.
I tried retoring the recent backup from the 2000 sql database that is sowing the errors in the 2005 sql develop and the error is still occuring.
Any help would be great.
The main cencern is getting it back to the 2005 without the error so when we stand up the new 2005 server.
Thanks
pete
February 8, 2008 at 8:25 am
Why didn't you just restore the 2005 backup on the 2005 server and continue from there? why take the data back to 2000 and then try to move forward to 2005 again?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 8, 2008 at 9:39 am
the 2005 went down and i have a standalone development server on a laptop. no 2005 servwer are available. i am trying test to the 2005 dev to get ready when the new 2005 comes online
thanks
February 8, 2008 at 10:45 am
Do you mean the 2005 installation is gone, or that it won't start up? (i.e. define 'gone down')
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 8, 2008 at 11:38 am
oh sorry the computer harddrive crash. nope of saving the original 2005 server install. i put it to a 2000 rather quickly so the users could have access it it.
February 9, 2008 at 12:04 pm
After doing some more looking around and trying third file imports it seems that before i imported the records from the 2000 box the records in the 2005 box did not show anything in the empty fields when you open them in enterprize manager but after the import all of the empty fields now show NULL and the same error occurs in the 2005 sql indicating invalid null use error 94.
Hope this helps
Pete
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply