Problem restoring database to a compressed drive.

I am learning how to use SMO and I have a test application that allows me to restore a database backup to a new database. On my system I have one physical drive but two logical drives on separate partitions. Drive C: is on a partition that is a FAT32 partition and drive D: is on a partition that is a NTFS partition and is a compressed partition. The database backup file is located on drive D:. When I try to restore the backup to a new database and provide a path on the D: drive in the RelocateFile object I get the following error message.

"The file 'D:\NPS_Test.mdf' is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

When I do a restore and indicate that the new database file will be located on the C: drive the restore works. I assume the problem has to do with the fact that drive D: is set up as a compressed drive, but I am not sure.

Does this mean that I cannot store a database file on a compressed drive or is there something I need to do to make it work?

Hi,

http://blogs.msdn.com/sqlblog/archive/2006/10/02/SQL-Server-databases-are-not-supported-on-compressed-volumes.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Problem linking to tables in SQL Server 2003 using MS-Access 2000

Hi,

I have an MS-Access database on a shared drive.The Access database has tables linked to a SQL server database.When I try to query the tables in MS-Access database by accessing the share drive,I get the ODBC--call failed error.So I tried creating an ODBC driver for the SQL Server and when I try to link the tables,no tables are displayed.Can anyone help me out with this problem?

-Ruth

If your Access Database has both Code and Data, you should separate them, Put the Data on the shared Drive,

The Code mdb is your client application and can be Linked to SQL-Server thru ODBC

create an ODBC connection to SQL-Server, So Your Client mdb app has both linked Tables to SQL Server and To the Shared Access Database.

You can not link to SQL Server thru an mdb indirectly.

|||

The mdb just has tables linked to SQL Server.I tried creating a ODBC and linking the tables.But it did not work.But when I tried to link to tables in the Northwind database,I am able to do so.I think it is a SQL Server access issue.But I am not sure where exactly the issue lies.

-Ruth

|||

Those are links to the SQL Server table, not the Actual table, so if you want, you can create link to SQL Server by Craeting a ODBC connection from your Control Panel.

Then in your Access app, add linked table using the DSN that you created.

You do not need an mdb on shared drive. if It does not have any local tables.

The once you compiled and distributed you app. On every PC, that it is installed the DSN should be created.