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 |
|
joseperez
Starting Member
1 Post |
 Posted - 2009-04-03 : 22:33:38
|
| I'm trying to replace a PC that runs SQL Server 2005 and I'm getting a strange behavior on the new PC, so perhaps someone may have an idea of what might be happening since I'm really new to this.So I had both PCs up and running and I made a backup of the databases on the old machine as *.bak files, as Full backups to restore on the new machine (right click > tasks > backup > backup type full, backup component database). The process went smoothly, I had to re-create the server logins and re-set the user mapping to each database but aside from that it didn't seem necessary to do anything else, is there ?This DB server talks to a web server running just four web sites using old asp 3. Out of these four, two seem to work ok, but the other two show really weird problems when using the new sql server. And these issues are not present on the old sql server. One of the sites is throwing an arithmetic overflow error coverting a value to SMALLDATETIME when I do a SELECT * FROM mytable WHERE CAST(myfield AS SMALLDATETIME) > 'somedate'. The exact same asp code works on the old sql server, no errors, same records. I really don't see anything bad with the dates, but still.And the other site uses AJAX to request XML from an asp web page that requests data from the sql server, builds the xml and sends it back. Well, this really is awful because with the new server it just doesn't work at all, the browser says the xml is not valid. I haven't had the time to debug the asp yet, but the old server works perfectly without errors so I was thinking this has to be some crucial detail that I'm not aware of. Perhaps there is something obvious I missed while doing the backup and restore of each database, does anyone have any ideas of what might be happening ?I'd really appreciate any thoughts or comments.Thank you very much in advance. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-04-04 : 19:06:59
|
| are you sure that both servers have the same sets of service packs applied? That seems like a good first place to start.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
|
|
Duplicate db on new hardware fails, old one works.