please, call me george.........

Yes, that is how you shrink in chunks, though I would go for smaller amounts.

Shrinks do not creatE much log and as your DB is in simple mode it...

if you use truncateonly the shrinkfile will not attempt to move any pages around so no fragmentation will be caused in this case.

Therefore this is safe to do and worth...

also aware this is an old post but it came top in a google search, so check this out as well

http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

niver (12/26/2013)

---

hi what will i do if my log ship failed to copy from primary and restoring is still working and some of the tran log backup has been deleted...

No

the error seems to suggest guest user has been removed from msdb, which some shops do for security reasons, has this been removed?

defyant_2004 (12/17/2013)

---

I am still not seeing what functions on the server they would need. If they can work in SSMS from their machine, why do they need to login...

defyant_2004 (12/16/2013)

---

We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in...

Who does? People who are not expert in SQL server?

Not sure what DAC enablement is for? If the server is down, we bring it...

...........and no they cannot do all their work via SSMS.

As a DBA I have performed all those other functions you mention and more

do they do installs? RDP is needed for that.

Is remote DAC enabled so DBAs could get on if SQL is unresponsive?

whilst all SQL based work can be done via SSMS...

presuming this is a user database you are trying to restore?

run select * from master..sysprocesses where db_name(dbid) = 'your database'

kill any spids this returns and run our restore (in the...

as elliot said, no.

indexdefrag is an online process so backing up your logs more frequently will help, the work done so far will be truncated.

You can reduce the amount odf logging by putting...