May 31, 2008 at 2:14 am
Dear All,
I have developed web application using sql server7.0.Now i want to upgrade my database sql server 7.0 to sql server 2005. I have configured sql server 7.0 compatability flag is set to sql server 2005. Its working fine.But transasction log is not generated in sql server2005.
i do not know the reason .Pls help me out
sethu
June 2, 2008 at 7:15 am
The first thing to check is your recovery model. Is it set to simple?
"Got no time for the jibba jabba!"
-B.A. Baracus
June 2, 2008 at 11:04 am
Transaction logs are ALWAYS used. Even in simple mode. They are cleared often, but they are still used.
Can you better explain what you think is happening by "not generated"?
June 2, 2008 at 11:53 am
Steve is of course correct... got into my head that you were referring to .TRN files, which is of course tran log backups, not the .ldf which is the tran log file itself.
I agree that the original post requires some clarification.
"Got no time for the jibba jabba!"
-B.A. Baracus
June 2, 2008 at 10:47 pm
Thanks all,
Actually .TRN file is not generated when i set sql server7.0 compatability set to sql server 2005 database. when i open to view sql server7.0 database to sql server 2005 object explorer i cannot able to view 7.0 databases. System shows only 2005 database and temp database. how can i view sqlserver7.0 databases in sql server2005 express object explorer?
Pls help me out
June 3, 2008 at 7:53 am
To the best of my knowledge, you can not administer SQL 7.0 databases from Management Studio. You can manage SQL 2000, but not 7.0.
"Got no time for the jibba jabba!"
-B.A. Baracus
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply