![]() 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. Open Backup and Restore by clicking the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking Backup and Restore. If I had to restore the production database I'd use the ISP's latest backup (SQL 2005). You can restore files from a backup that was created on another computer running Windows Vista or Windows 7. 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. 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. Press Next > on the Restore system files and settings window that should have appeared on the screen. Is this a known problem with SQL Server Express 2005 and 64 bit Windows 7? What should I be doing that I'm not? How to Use System Restore in Windows 7 or Windows Vista Navigate to the Start > All Programs > Accessories > System Tools program group. 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). 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: 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |