1. Why are the increments of transaction logs different on different SQL Servers?
2. Cannot shrink transaction log of a SQL Server 2005 db
I have a SQL Server 2005 db for a Navision installation.
I have tried to execute DBCC Shrinkfile on the related transaction log after
the running of backup log. I have had this error:
"Cannot shrink log file 2 (...) because all logical log files are in use".
The transaction log is of 15 GB!
I know that it is possible to reduce the space of the log while the db is in
use.
How can I solve this issue?
Many thanks
3. Sql Server 2000 restore to different db name?
4. Restore sql server express bak file as different db?
5. Restore Sql Server 2005 db to Sql Server 2000
6. SQL 2000 + SQL 2005 Express Compatibility (restore SQL 2005 DB with 2000 DB)
7. PTS -> Firewall -> Web Server -> Firewall -> Web Server/Analysis Server set up
9. Unable to discover SQL server 2005 DB engine on a Clustered SQL Se
10. Upgrade of SQL Server 2000 DB to SQL Server 2005 DB
11. Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??
12. Moving SQL DB to new server with different DB name
13. ADO & SQL Sever - 1 ADO transaction covering 2 different databases on same SQL Server?
14. Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??
15. SQL Server 2005 transaction log backup view t-sql statement empty