Viewing 15 posts - 5,341 through 5,355 (of 9,253 total)
ananda.murugesan (7/12/2012)
1. If more then 200GB primary data file reached, I assumed need to create one more datafile for improve database perfromance?
That assumption is incorrect.
ananda.murugesan (7/12/2012)
July 12, 2012 at 7:15 am
if your secondary ever shuts down again for long periods either keep a copy of the backups that havent been restored or perform a differential on the primary and apply...
July 12, 2012 at 6:46 am
Sorry I'm confused I thought we were discussing log shipping!!
The backup and restore information is held in MSDB, query the tables here for this info
July 12, 2012 at 1:07 am
Firstly, you seem to have a misunderstanding of files and filegroups, take a look in books online and familiarise yourself with them. Now to cover your questions
ananda.murugesan (7/12/2012)
July 12, 2012 at 1:04 am
Shaira (7/10/2012)
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...
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...
July 11, 2012 at 11:30 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...
July 11, 2012 at 10:00 am
Jack Corbett (7/11/2012)
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...
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...
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...
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...
July 11, 2012 at 7:41 am
Viewing 15 posts - 5,341 through 5,355 (of 9,253 total)