Backup a SQL 6.5 Compatible Database in SQL 2005
I have an application that uses a SQL 6.5 Database. I have upgraded my SQL to 2005 and attached the SQL 6.5 database and I am using the Application fine with no problem. All the other database on the SQL database have been upgraded except for the above.
When I look at the database in the Microsoft SQL Management Studio, it shows the database with (6.5 Compatible) and I can not backup, no can it be backed up usinf the DB management. The only way to back up is to stop the SQL services, copy the MDF and LDF files. Is there another easier, or automatic way to back up without spending money on special backup software.
Thanks,
Bilal
When I look at the database in the Microsoft SQL Management Studio, it shows the database with (6.5 Compatible) and I can not backup, no can it be backed up usinf the DB management. The only way to back up is to stop the SQL services, copy the MDF and LDF files. Is there another easier, or automatic way to back up without spending money on special backup software.
Thanks,
Bilal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Could you provide me with step by step instructions on setting this up as an automated process? I am not familiar with T-SQL. You can send link to articles that have examples.
Thanks,