shamil at smsconsulting.spb.ru
Sat Oct 16 07:06:59 CDT 2010
Hi All -- It happens that MS SQL 2008 and MS SQL 2008 R2 have incompatible backup format - the ones created by MS SQL 2008 R2 can't be used to restore MS SQL 2008 databases. This issue is a RPITA here now as I have got upgraded both my development PCs to MS SQL 208 R2 and my Windows Hosting provider has MS SQL 2008 only and no near future plans to upgrage to MS SQL 2008 R2. BTW, I have checked several well known Windows Hosting providers - they do not have MS SQL 2008 R2 installed, and also no near future plans to upgrade to MS SQL 2008 R2. Or it there a feature which I'm currently missing which will allow to make MS SQL 2008 R2 DB's backup in MS SQL 2008 format? What happens is that if I setup a MS SQL 2008 db on my Web hosting, then work with it (e.g. via DNN), and then I get its backup downloaded and installed locally on MS SQL 2008 R2 - that goes smoothly but I then will not be able to make local backup using MS SQL 2008 R2 to uploaded it and restore on my web hosting site :( Thank you. -- Shamil P.S. Yes, I can setup MS SQL 2005 Express in parallel to MS SQL 2008 R2 - that works OK, but I didn't try to install MS SQL 2008 - would that work?
More information about the dba-VB mailing list