?

Patricia

check for a SQL Server agent job that executes against the Insight database and contains a step that manually truncates the log. I had this issue previously with another application...

What operating system are you using on the cluster nodes and the stand alone server?

Is the stand alone server completely stand alone or is it a member of the same...

Best to stop the job really so it releases locks. Go into Computer Management and view open files there.

this is already in discussion at the link posted by LutzM

Ok, thats undoubtedly part of the issue. You must use SQL Server configuration manager to change the service user account\password credentials!

Note: Local system will automatically have full rights to...

how are you changing the user account for the sql server service?

have you checked the net backup job status?

Sp_help shows you the default which looks like it's using the default (1, 1). This happens if you do not supply values during the creation phase. Design the table in...

Check the Redgate SQLBackup logs for details of any potential errors or warnings

ocolakoglu (11/20/2010)

Last week we upgraded our system

Sql server 2005 to Sql server 2008

Windows 2003 to Windows 2008

32 cpu 64 gb ram to 64 cpu 256 gb ram

One server strcuture...

Sree-258588 (11/19/2010)

I've table with THE following structure:

id int identity(1,1)

name varchar(100) not null

id is the primary key

now I want to change the identity (0,1)

set the seed value to 0

I've...

have you exposed the LUN to both servers?

Could be overkill, how many logical processors do you have?

I would also add the auth_scheme column to Lowell's query to check for NTLM or Kerberos authentication type.