Viewing 15 posts - 4,591 through 4,605 (of 9,241 total)
Jeetendra (11/19/2012)
I am trying to install Multiple instances of SQL Server 2008 R2 on a Windows Cluster in a Active / Passive Mode.
I have installed the Default Instance of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 4:12 am
Dustin W. Jones (11/19/2012)
is AONode2\CLMaint. Is this node necessary? Is this just another secondary replica?
That's exactly what it is, a secondary replica.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 2:07 pm
sqlnyc (11/19/2012)
The irony here is that we deleted all of those records so that we could save space. But obviously that never happened.....
The ghost cleanup is a periodic background task....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 1:31 pm
sqlnyc (11/19/2012)
Guess I'll have to do some research as to why they're not getting cleaned up in production.
Sql server version may be the issue, check for any patches that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 1:19 pm
sqlnyc (11/19/2012)
Yes, we have recently deleted a large amount of rows. In fact I was just in touch with Paul Randal about this, and he suggested that it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 1:15 pm
Have large amounts of data been dropped on the source database from this table at all.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 12:32 pm
arkiboys (11/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 9:33 am
Slipstreaming is performed at install time and can merge an install media with an SP and\or CU on the fly.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 8:51 am
can you post the column definitions for the table and the backup script you are using to take the backup on the new server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 8:49 am
arkiboys (11/19/2012)
1-Do you mean to overwrite?
No, write to a new file each time with a unique name
arkiboys (11/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 7:30 am
DBCC UPDATEUSAGE, that'll be the culprit 😉
Just out of interest, does the backup\restore cross database version?
I.e. are you restoring from SQL2000 to SQL2008 for instance?
Do you have the output from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 2:37 am
saidapurs (11/19/2012)
Hi Gila,Can it is possible with replication (primary server)?
Satish
A simple search of the Microsoft site produces this link
http://msdn.microsoft.com/en-us/library/ms151799.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 1:45 am
tinakothari (11/18/2012)
in this table i want to insert about all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2012 at 2:08 pm
ARCGIS or ARCSDE may use either an oracle or sql server RDBMS, it wouldn't be my preference to install the GIS system on the database server as these systems can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2012 at 1:21 pm
bugg (11/18/2012)
I will double check how far back the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2012 at 1:08 pm
Viewing 15 posts - 4,591 through 4,605 (of 9,241 total)