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

ocolakoglu (11/20/2010)

---

Hi,

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)

---

Hi

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.

are you looking to get the IP address of the client connecting to SQL Server?

I have only seen this when...

Be aware the shrink may have no effect on some log files. If the active portion of the log occupies the end of the file you may not shrink below...

this is a known issue, it's almost certainly the indexes holding the space. The data pages are not deleted just deallocated, it makes roll back...

why are you repairing, you were supposed to be adding a node on node b and selecting the existing clustered default instance?

BIDS executes under your windows user account so that will be golden 😉

Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql server account,...

either the data source does not exist or it is in another folder on the SSRS instance. In report manager select the report and go to the data source option...

hydbadrose (11/14/2010)

---

Thank you so much for your help! Can you also please send me the link or document to change to change the SQL services account password on cluster environment...

They never miss you until you're gone 😉