I have a MS SQL database that is used in an old proprietary program. Currently the datafile is running on a server that has SQL server 2008 on it. When I open SQL 2008 management studio, I can see the database, but none of the tables show up.
Instead I get an error message about running dbcc check data. However, when I attach to this instance from another server running SQL 2005, I can view the tables and run querys on it. The program currently works fine, but I need to make sure I
can do proper backup and restores. If I try to run a back up in 2008 managment studio I get an error, if I run the backup from the other server with management studio 2005 I get a successful backup. However, when I copy the backed up file from
the production server to the one where I have 2005 installed, I can't restore the database. Can anyone guide me in how to solve the problem?
View Complete Post