Viewing 15 posts - 1 through 15 (of 40 total)
This is by ssms using generate script task.
January 27, 2012 at 8:37 am
Here is script to copy the schema
January 27, 2012 at 8:35 am
You can use both Rtrim and Ltrim at a time to get rid from both prefix and suffix.
Select Ltrim(rtrim(column))
January 27, 2012 at 3:49 am
Is there any specific error you are seeing in logshipping monitor or in error log?
January 27, 2012 at 3:30 am
For me also it's working. mine also same SQl Server 2008 SP1
January 27, 2012 at 3:19 am
January 27, 2012 at 1:35 am
What is recovery model of your database? if it is full then you have to change it to bulk logged recovery.
January 27, 2012 at 1:20 am
For resolving the logshipping out of sync issue. generally you have restore the full backup of your primary database to secondary server.
January 27, 2012 at 1:17 am
Please post the Query execution plan. it will help to analyse more.
January 26, 2012 at 10:12 am
you can try with powershell to extract data from SQL server.
Here is some example.
January 26, 2012 at 8:45 am
what is the value for counter Physical Disk Object: Avg. Disk Queue Length?
Please provide the drive details like RAID type that you are using?
January 26, 2012 at 8:33 am
use below query
select database_name, type, first_lsn, last_lsn ,checkpoint_lsn ,database_backup_lsn
from msdb..backupset where database_name = 'DBNAme'
January 26, 2012 at 7:50 am
Viewing 15 posts - 1 through 15 (of 40 total)