Click here to Skip to main content
15,891,372 members

Comments by sameer112 (Top 5 by date)

sameer112 24-Dec-14 14:20pm View    
Thank you Maciej los
After restarting both server solution worked.
sameer112 13-Dec-14 11:10am View    
I have installed the latest version of sqlserver but still having same error?

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <x64> (Build 7601: Service Pack 1)
sameer112 13-Dec-14 0:11am View    
Maciej Los,
I added the key SynAttackProtect in the registry and also restarted the server but no effect still having the same error. I checked the TCP/IP and named pipes are also enabled . The firewall is disabled in both servers.
sameer112 9-Sep-13 9:14am View    
yes i have a server setup by using log shipping .trn files... i create some fields in the tables in principal server database.i open the sqlserver for standy database and find that there is no fields exists which are created in principal server database. Is .trn files only takes the transactions not columns ... if it is like that help me what i can do ?
sameer112 11-Dec-12 15:26pm View    
Deleted
I am using the link script it runs fine show message
RESTORE DATABASE XYZ WITH RECOVERY
but unable to restore the backup for directory my backup file name below in the same directory 'D:\SQLBackups\'
My backup db name below
Backups_20121211140724.bak

Thanks