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 Server won't start **** AARRGGHHH!!!****

Status
Not open for further replies.
CInman

CInman

IS-IT--Management
Mar 15, 2001
81
0
0
GB
A SQL Server 7.0 won't start, saying that one of the datbases' logfile is full. I'm cool with clearing down full logfiles, but I don't understand how SQL Server won't start due to one being full? Of course, because it won't start, I cannot do anything ... ANY IDEAS ANYONE PLEASE VERY GRATEFULLY RECEIVED :)
 
Sort by date Sort by votes
Check you have enough disk space ! ________________________________________________________________________________
If you do not like change, get out of the IT business...
 
Upvote 0 Downvote
... thanks mate, but I've checked that and its not the problem. It tells me that database "Sunrise" has a full logfile and therefore refuses to start SQL Server ... how bizarre!?!
 
Upvote 0 Downvote
One way to do is that get the backup of that log file and then delete it and then create new log file to that "Sunrise.ldf" it think that would do it.

take care,
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
200
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
163
pjw001
pjw001
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
119
Andrzejek
Andrzejek
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
117
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
102
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top