OLA has the answer 🙂

ramyours2003 (5/20/2015)

---

there is no GUI installed in my environment , i need to uninstall the sql 2014 through command prompt ..

can any one provide the steps for uninstalling the sql...

oops sorry then Wrong suggestion

but then try the other one

go with ssis or

go with batch file

GilaMonster (5/20/2015)

---

Log_reuse_wait has nothing to do with the log not shrinking. It tells...

The Open Query Is also an option for you i guess

google something on Openquerry

Yes there has to be something in query which will be selecting...

as said earlier .. check the reason of log not shrinking

in log _reuse_wait column

and to reduce the no of VLF

keep the autogrowth to approx of 1...

Grant Fritchey (5/19/2015)

---

It sounds like there are a lot of different problems going on here. I recognize that you're focused on the memory, but you need to step back from...

GilaMonster (5/19/2015)

---

Yes. Do...

try this

https://www.virtualobjectives.com.au/sqlserver/saving_to_html.htm

it will help you

step by step guidance for sending nice formatted html

select * from sys.databases

run this query

it will tell you why the log files are not getting reuse

it will have reason in column log_reuse_wait

ramana3327 (5/14/2015)

---

Hi,

I want to run this below query on scheduled basis and send the result to me through Sql job. It is running but not sending any result

How to set...

try SQL server's feature --- Central management . you can register all the server and perform transaction without logging to that server

basic condition is that your SQL...

you can use looping feature of SSIS and pass the variable as and when require

Yes Restarting The server will stop the SQL server cleanly . as windows always shut down all the application before shutting itself down

and SQL works On write Ahead log...