I dont think you can just restore a MDF file avoiding LDF from a full backup file.

Attach, detach will do. You should be able to attach the database with just...

Hi Justin,

good to see your post. I am new to powershell, and just the same thing I am looking for, to pull details from all the servers in the environment...

Thanks much Lowell.

I will try and update. I am worried if I run this tool in my environment, may be in a centralised server, it will send alerts to network...

Thank You very much for your efforts and help towards my issue.

I tried with the tool 'MAP' you specified, but it is not deteting the Domain group.

Trying many options, but...

Kleeeek...:w00t:

I am good to learn new techies.. But, its a mandatory thing to report today.

Trying to get it done.

Thanks.

Thanks for your prompt response.

I used a powershell script, which resulted local machines report.

I am not that much familier with PowerShell. If there is something that I can fetch the...

I tried starting SQL Server Agent through Management Studio. I got below exception.

Did anyone faced the problem.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead...

My instances are running under LocalSystem service.

I installed 2nd instance also, same error.

I checked instance properties, permissions from management studio.

I found - "could not obtain inofrmation about Windows NT...

Microsoft SQL Server 2008 (CTP) - 10.0.1442.32 (Intel X86) May 30 2008 00:02:15 Copyright (c) 1988-2007 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.1...

Thanks

Thanks for your replies Experts,

I have a scheduled job indexing for every week end. Its for Re-Indexing on every sunday night.

Not done for update statics.

Poor Queries are tuned and the...

Thanks for the response,

Memory on sql is this set to a limit for min and max and have you done lock in memory on windows too. This pervents OS Paging...

Thanks for the reply Gail.

I have already started working on the long running queries and the procedures. Done rewriting the queries and reduced the execution timings for the procedures as...

Any Inputs on this...... Please post if any one has any thoughts..........

Timeout set :

sessionState mode="InProc" cookieless="false" timeout="60"

httpRuntime maxRequestLength="2097151" executionTimeout="900"

customErrors mode="RemoteOnly" defaultRedirect="UnexpectedError.htm"

as in the web.config file...

Any help on this....

There is huge increase in TIMEOUT errors day by day...