Skip to Content
0
Former Member
Jul 21, 2008 at 05:01 PM

space problem

25 Views

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?