I have problem
I am using mssql2005/win2003 ecc6. the problem is a space problem.
Namely someone (probably network administrator) switched off backup of transaction log.
I have only 500 Mb free(all is on drive c: as we are speaking aout a small system).
35G of transaction log shold be cut off.
1.
I have heard it is possible to detach database , delete transaction log and attach database.
If so that is no problem(how can I see the database is up and running- assuming this is prerequisite)
2.
Is it possible to backup transaction log on an mapped network disk?
3. do yo have an other idea?