My real question is, can I run a SQL database with a compatibility level of 80 in a SQL Server 2008 Express server, for testing purposes only? All I'm really doing is supporting a DotNetNuke 4.9.5 site. The purpose of the test site is to allow me to check out new functionality, and test and document upgrade procedures before doing them on the production site, it isn't a formal backup from which I could restore. If I had to restore the production database I'd use the ISP's latest backup (SQL 2005). Your point about being unable to restore a 2008 database from a 2005 backup is true but I'm not sure it's relevant I would never try to restore the production database (2005) from the test site database (possibly 2008). I'll have to do some more research on this issue. If I read your suggestion correctly, I can change the compatibility level merely by changing the number and then doing another backup and restore? This seems too good to be true. So when making a change, create a restore point first and then backup the only edited section manually. My ISP tech support staff have just confirmed my suspicion that my database's compatibility level is 80 it was originally built on SQL Server 2000. The best option to backup and restore the entire registry is to use System Restore. Is this a known problem with SQL Server Express 2005 and 64 bit Windows 7? What should I be doing that I'm not? When the install says it's complete, I have no Surface Area configuration tool in my start menu, and Management Studio Express can't find a local database server to connect to. I searched the log directory for the string "database services" and found nothing usable. It refers me to the setup log for detail but when I click on the link nothing comes up. (I can't find such a file on my disk.)Īctually with SP3 I got a new error: SQL Server Database Services install failed. It complains that it can't find the installation package for Microsoft SQL Server Native Client and says to try again with the installation package sqlncli_圆4.msi. A compatibility check said, not compatible.) (I tried downloading and installing a 32-bit ASP.Net package and the installer wouldn't even run. It complains that only 64-bit ASP.Net is registered and it needs 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit). Press Next > on the Restore system files and settings window that should have appeared on the screen. ![]() The Windows 7 answer site suggested I needed SP3, so I downloaded the SP3 installer (the EXE) but I get the same errors I got with the unpatched version: How to Use System Restore in Windows 7 or Windows Vista Navigate to the Start > All Programs > Accessories > System Tools program group. I'm trying to rebuild my web development interface, which means I'm trying to install SQL Server Express 2005 and SQL Server Management Studio Express 2005, which I've been using on Vista. I recently rebuilt my Windows Vista Home Premium laptop with Windows 7 Ultimate I also went from 32-bit to 64-bit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |