I have doubt..

Log shipping process have been configured on the primary database also transaction logs apply to secondary database instance, then after create new db user in primary instance then...

Thanks for reply..

I try to created new user & login on the secondary server instance, but still facing same issues...not able to create new user on the standby read-only daabase

Error...

1. For the logshipping configuration, Should I remove the existing Tlog backup Job in sql agent? I have deleted existing backup jobs due to mismatch LSN.

if remove existing Tlog backup...

I have tested only LOG SHIPPING with Test server, it was working fine after 2 days watching and monitoring logshipping activity then going to configure production servers.

Please verify and suggestion...

Thanks for reply...

1. Principal database - Primary server

2. Mirror database - secondary server

These two servers data has been synchronized between two servers with HIGH SAFTY mode mirror operations.

I have doubts.

From...

sorry Boss, the same error come again

I m using SQL 2K8 R2 64 bit-version.

IF EXISTS(SELECT 1 FROM sys.objects where name='NewTable' and type='U')

begin

DROP TABLE NewTable

end

GO

select *

into NewTable from tbl_contract_emp_master...

error

Msg 2705, Level 16, State 3, Line 1

Column names in each table must be unique. Column name 'STATUS' in table 'NewTable' is specified more than once.

1.

[TBL_IRIS_IMAGES_MASTER]

[GUID] [varchar](50) NOT NULL,

[LEFT_IMAGE]...

problem resolved after enable file sharing port number 445,

now database has been synchronized mode between two servers.

I have configured High performance mode for DR setup..

Thanks for reply..

what could be bigger issues if using NT Authority/Network Service account in SQL server service? Pl. suggestion me

Mr. Perry, I have one question?

1. Principal server

SQL service account running under NT authority/Networkservice

2. Mirror server

SQL service account running domain account..

can we configure database mirroring on different service account,...

Great, I got reply from script author Mr. Ola Hallengren.

I have configured index rebuild on weekly basis at 3 AM..in production server,

I have checked at 9 AM there is...

opc.three (9/27/2012)

---

Have a look at Ola Hallengren's Database Backup script. It does what you're wanting and if setup in a SQL Agent job you can send an email if the...

Thank you for your reply...

Total server memory 8 GB, I have set it max memory 6GB but SQL side using 5.79 GB, so it seems ok in sql side. But...

ok, I had developed SSRS reporting services in development setup for monitoring sql server database like backup overdue, failed jobs etc.. it is working fine local instance databases.

How to connect...

Pl. provide, any open source webpage script is available?