Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

space problem

Former Member
0 Likes
359

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?

1 ACCEPTED SOLUTION
Read only

Former Member
1 REPLY 1
Read only

Former Member