Nope. Unless you were tracking and logging that information there is no way to go back 3 months ago and see the execution time. In addition the DMV...

I think page faults are bit high but doesn't mean SQL Server is under memory pressure; it is your OS is complaining "a bit" or other processes running on the...

Maybe the transaction is being rolled back because of Triggers?

Mohit.

For test Data generation RedGate Data Generator ROX! Best tool ever ;-).

Mohit.

Okay in that process you did not grant the login any permissions to the database. This is just creating a server login; now you have to create a database...

As George said re-install might be you only open; but from your previous screen shots some components did get installed.

When you were installing did by chance enter another folder for...

I don't know how to translate that number; few times I ran into it I couldn't figure out. I got lucky that someone else had ran into exact same...

These are correct; but please go to that path C:\Program Files\Microsoft SQL Server\MSSQL.1\ and see if said files exist in...

Hi,

No it doesn't mean there is memory pressure; the target memory value is taken from the maximum memory setting. And the server usage means that SQL...

It is an issue with quotes .. try

EXEC ('create proc BULK_INSERT_DATA ( @caminho varchar(500) )

as

set xact_abort on

set nocount on

declare @SQLStatement as varchar(500)

truncate table bulk_Contribuintesest

set @SQLStatement = ( ''BULK INSERT...

Check to confirm the SQL Install completed successfully and your setup path information for the master database is correct.

You can you use "SQL Server Configuration Manager" to see the startup...

Try using ..

RESTORE headeronly FROM DISK = 'bkfilename.bak'

This will give you the version under SoftwareVersionMajor, SoftwareVersionMinor, and SoftwareVersionBuild.

From the build you can go to http://sqlserverbuilds.blogspot.com/ to see what...

I am sorry I haven't used Log Shipping much other then searching on Google; I couldn't provide much help. I hope someone else can point you to proper resources.

Thanks.

My searching only found ...

http://blogs.technet.com/wbaer/archive/2008/03/13/sql-server-2000-2005-log-shipping-notes-with-sharepoint-products-and-technologies.aspx

Another note while searching I found while reading the white paper above Mirroring is not 100% automatic failover with sharepoint technolgoies because the front...

Please check ..

1) Firewall (Any changes that would start blocking port 1433)?

2) Remote access still enabled on TCP/IP.

3) MSSQL Server is running.

Any patching?

Mohit.