one more question?

As per BOL http://msdn.microsoft.com/en-us/library/ms189434(v=SQL.105).aspx

when using windows authentication, SQL Engine account should be domain account for configure database mirroring.

as per my current instance can login mixed mode authentication such...

As per domain policy, SQL service account not given to permission for login that server.

Can we possible configure NT authority /Network service - this account assign SQL engine for mirroring...

thanks for reply...

Ok, domain account should be required to configure database mirroring also principal & mirror server SQL engine should be running same domain account.

Does domain account should be added...

yes, your correct direction in that execution plan.. i am not witting that code

one of the devleoper wirtting like this, after that he called me you increase the performance....

please confirm.

I thought my production server is settle under memory usages.

I did configuration as below

1. set the max memory 6GB (dedicated SQL machine), total 8 GB.

2. configured Lock page memory

(service...

please confirm.

I thought my production server is settle under memory usages.

I did configuration as below

1. set the max memory 6GB (dedicated SQL machine), total 8 GB.

2. configured Lock page memory

...

as per your server h/w disk configuration, might be useful as following condition

what is your server model?

what OS version to be installed?

How many disk array controller that server?

If server have...

GilaMonster (8/23/2012)

---

No, thread stacks do not use memory in the buffer pool, they use the non-buffer memory.

CLR disabled does not mean no CLR. The system assemblies can still be used....

ok, understand why it is using more memory due to backup buffer, and thread stack..

In this server not enable CLR,

also Linked server not created..

each thread stack using 512...

ok, thanks for reply..

I am going for choosing Synchronous Mirroring (without witness server, manual failover process) , and writting data at a time at mirror server disk.

principal/ mirror server...

Mirroring...

yes, we have discuss with vendor as well as application owner, they are accepting as following condition.

OS - Win 2008 R2 64bit enterprise edition

DB - SQL server 2008 R2 enterprise...

thank you all.. finally database being executing for restore as below command , as well as created database files same like existing as per sql 2000.

use master

go

RESTORE DATABASE [TELE]...

yes.. source database SQL 2000 have mulitple data & log files.

I caputred the script in SSMS throu database restore option.

RESTORE DATABASE [TELE] FROM DISK =

N'E:\TELE_Backup\TELE\TELE_201208021156.BAK' WITH FILE...

First time Restore database from SQL server 2000 backup files.

By default create multiple MDF file and log file in SQL server 2008.