Viewing 15 posts - 5,341 through 5,355 (of 9,244 total)
Shaira (7/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 2:15 pm
SQLQuest29 (7/11/2012)
Very helpful.
Out of curiosity, is there any way that the relation between the disk# and the drive (e.g c: ,d:) can be found meaning they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 1:41 pm
That statement is based on the example immediately preceeding it.
Start from the heading Partition Alignment on page 25 and read through thoroughly. This is descriptive of the requirements
EMC Symmetrix with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 11:30 am
it's no problem
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 10:41 am
SQLQuest29 (7/11/2012)
64 KB is typically the minimum (and a common) valid starting partition offset for SQL Server -- This is where I am confused
ah, ok let me see if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 10:00 am
Jack Corbett (7/11/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 9:42 am
bubby (7/11/2012)
Could you please let me know how the index is related to the table, I mean if the table is used quite often, How the index size works,
to help...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 8:53 am
lisa.randles (7/10/2012)
Also, when I query sys.columns and sys.objects for object_id 1357963914 I do not get any records returned.Any information you have to offer would be greatly appreciated. TIA!
No records...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 8:38 am
jitendra.padhiyar (7/11/2012)
Is there any query or any DBCC or any DMV check to find out which transaction log backup last restored?
exec sp_help_log_shipping_secondary_database
@secondary_database = 'yourdatabase'
jitendra.padhiyar (7/11/2012)
Secondary_id=D737BE9C-2500-4B51-9CE1-B36E56846A4C
Primary_server=JPTEST\SQLLOCAL
Primary_database=AdventureWorksDW
Backup_source_directory=\\192.10.10.1\Backup_Ls
Backup_destination_directory=E:\Restore
File_retention_period=30
Copy_job_id=571602CF-1CCF-430C-LAKDJ345-AKDFK12
Restore_job_id= C3B9AA9A-C3AD-A411-9477-D7654423
Monitor_server=NULL
Monitor_server_security_mode-Null
Secondary_database=AdventureWorksDW
Restore_delay=1
Restore_all=1
Restore_mode=1
Disconnect_users=0
block_size= -1
buffer_count= -1
max_transfer_size= -1
restore_threshold=45
threshold_alert=14421
threshold_alert_enabled=1
last_copied_file=E:\Restore\AdventureWorksDW_2012071017512.trn
Last_copied_date= 2012-07-10...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 8:21 am
SQLQuest29 (7/11/2012)
Still confused with http://msdn.microsoft.com/en-us/library/dd758814.aspx
Valid Starting Partition Offsets
Because versions of Windows earlier than and including Windows Server 2003 comply with the 63...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 7:41 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 7:21 am
you'll be adding the node back to the current instance not creating a new one!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 4:39 am
try just uninstalling sql server first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 4:00 am
MBR limits partitions to 2TB, where as GPT doesn't, it's a lot larger than that.
The main restriction with MBR is the fact it will only support 4 partitions max, where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 3:44 am
I would uninstall\remove the node that's causing the issue and re install it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 1:02 am
Viewing 15 posts - 5,341 through 5,355 (of 9,244 total)