Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Log files

Status
Not open for further replies.
ninhovid

ninhovid

Technical User
Jul 1, 2003
29
0
0
MX
hi everybody...

i'm having some space problems...
i have a database whose log file is almost 7 gb big! (.ldf)
how can i reset it? it doesnt matter if i can restore it from logs... i do backups everday (.BAK) and i would restore it that way..

thanks in advance...
 
Sort by date Sort by votes
What database product are you using? (I suppose you'd get a faster respons if you try a dbms specific forumm, since ANSI SQL is generel and doesn't mention log files.)
 
Upvote 0 Downvote
sorry...
i've already posted in setup and admin....
and they have replied

i'm using sql server 2000....
thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
68
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
59
JarlH
JarlH
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
71
soushi01
soushi01
jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
67
JarlH
JarlH
Pearlios
  • Locked
  • Question
SQL Keys and diagram
Replies
1
Views
46
r937
r937

Part and Inventory Search

Sponsor

Back
Top