Viewing 15 posts - 5,341 through 5,355 (of 9,241 total)
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
amitsingh308 (7/11/2012)
will you please explain it
When you drop objects from the database the files do not automatically reduce in physical size
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2012 at 1:00 am
SQLQuest29 (7/10/2012)
1. BytesPerCluster for SQLServer should be 65,535 bytes (= 64K) as sql server performs I/O based on an extent (8 8KB pages = 64KB).
Optimal stripe sizes for SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 5:35 pm
Nicholas Cain (7/10/2012)
Have you looked for errors on the log shipping monitor
There is no monitor server, the return value for this in sp help log shipping primary database was null.
jitendra.padhiyar...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 4:58 pm
Viewing 15 posts - 5,341 through 5,355 (of 9,241 total)