View Complete Post
I have added SQL Server 2008 Dlls as a reference in Visual Studio 2005 C# .Net code.My requirement is my application should run for both Sql 2005 as well as Sql 2008.
But the application is not working for SQL 2005.
Can anyOne knows whether SQL Server 2008 Dlls are backward compatible with SQL Server 2005.
I have been working on a database on my laptop that has SQL Server 2008 Ktma installed.
The database was restored from a full backup that I had taken from the production SQL 2005 server.
Now that I have finished my job I want to restore it back to the production Server (SQL 2005). I took the backup with "No compression" on a disk file through the SQL 2008 Management studio.
However when trying to restore the SQL 2008 backup onto the SQL server 2005 I get an error:
The media family on device xxxx is incorreclty formed ....
Can someone help me on this. Is it possible that sql 2008 backups are not compatible to the sql 2005 structure?
Is there anyway to have my database restored back on the sql server 2005?
Thank you in advance,
PS: It is not an issue of malformed file since I did the process several times (taking the backup, coping to the sql server 2005 machine).
When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.
So how can I get around these problems?
I need to use Visual Studio 2005 to create the Integration Services packages.
Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?
Thanks in advance.
i cant install sql server 2005 nor 2008 on my windows 7 os
i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,
can you plz help me??