Viewing 15 posts - 7,381 through 7,395 (of 9,244 total)
Buzz-523717 (11/19/2010)
executing master..sqlbackup in a script step of the scheduled job.
Check the Redgate SQLBackup logs for details of any potential errors or warnings
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2010 at 3:27 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2010 at 11:58 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2010 at 11:23 am
have you exposed the LUN to both servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2010 at 7:12 am
MysteryJimbo (11/18/2010)
Guestimate of 6 x 2Gb to ensure proportional fill.
Could be overkill, how many logical processors do you have?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2010 at 8:53 am
I would also add the auth_scheme column to Lowell's query to check for NTLM or Kerberos authentication type.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 7:49 am
are you looking to get the IP address of the client connecting to SQL Server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 5:17 am
Scott Ohar (8/11/2009)
Hmm, thats odd. I've had no issues, just stating how to address that issue which a clustering engineer from microsoft recommened to do.
I have only seen this when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 3:03 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2010 at 1:57 am
paul.olson.dba (11/15/2010)
I have tried rebuilding indexes,
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:42 pm
why are you repairing, you were supposed to be adding a node on node b and selecting the existing clustered default instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:22 pm
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 1:22 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 11:58 am
hydbadrose (11/14/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 4:21 am
They never miss you until you're gone 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2010 at 3:43 am
Viewing 15 posts - 7,381 through 7,395 (of 9,244 total)