bsarahim
asked on
sql server % of logs filled and clean up
i have a restricted growth setting for 2 transcations logs(.ldf) for one sql server db(Simple recovery).
where I can the see the % of logs filled
and what can i do clean up? shrink log or db?
and db for mdf and ndf is in unrestricted growth
will the transactions logs commit to .mdf or ndf or clean up the .ldf, once sql server is restarted?
customer is doing lot of inserts, updates,etc I guess logs will fill up immediately
Thanks
where I can the see the % of logs filled
and what can i do clean up? shrink log or db?
and db for mdf and ndf is in unrestricted growth
will the transactions logs commit to .mdf or ndf or clean up the .ldf, once sql server is restarted?
customer is doing lot of inserts, updates,etc I guess logs will fill up immediately
Thanks
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 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.
bsarahim, is this issue solved or do you need more help on this?
A feedback will be appreciated.
Cheers
A feedback will be appreciated.
Cheers
Recommendation to close this question by accepting the above comments as solution.
ASKER
and T-SQL to shirk the logs and database
the application design has 2. ldf files..
Thanks