Viewing 15 posts - 4,591 through 4,605 (of 9,244 total)
SQLCrazyCertified (11/20/2012)
I was troubleshooting a connectivity issue for a cluster server.
SQL 2k5 on Windows 2k3.
Found an instance is down, manually brought back online. However, I am wondering howcome...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 11:13 am
Commonly a network error, what testing did you perform to ensure the default of 10 secs was sufficient to mitigate potential issues on your network?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 4:37 am
what is the timeout value you are using for this database?
select mirroring_connection_timeout from sys.database_mirroring
where database_id = DB_ID('yourdb')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2012 at 4:16 am
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
Viewing 15 posts - 4,591 through 4,605 (of 9,244 total)