sonu19
asked on
Question about SqlServer Transaction Log File
Hey Guys,
My Sql Server transaction Log is now 1.4 Gig and my Database size is 1.o GIG.
Is this common or can I clean up the Transaction Log?
How can I go about cleaning the Log?
I am looking to boost the performance of Sql Server
Thanks
My Sql Server transaction Log is now 1.4 Gig and my Database size is 1.o GIG.
Is this common or can I clean up the Transaction Log?
How can I go about cleaning the Log?
I am looking to boost the performance of Sql Server
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I dont see anything to select Transaction log all I see is the delete inactive activity from transaction log
i am on a sql server enterprise manager
i am on a sql server enterprise manager
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).