Create a domain user, let us call it test1

Create a local user in both the SQL Servers in both domains with the same name test1 and also the same password....

You have to Create Login. Only after that can you do a Grant.

http://msdn.microsoft.com/en-us/library/ms189751(SQL.90).aspx

Or Books Online will give you the complete syntax for Create login.

Not exactly. If you want to see the size of the Transaction log, you should set the DB mode as FULL. Only then will it write to transaction log and...

You will get the data till the last transaction Log was taken. Let us say you are doing transaction logs every 12 Hrs. First one at 12 Midnight and the...

Thank you Thank you.... 🙂

I wish I was even 50% as good as some of you folks are...:-)

I am into my 1000 + posts. So as per some people I am a Guru... Buahahahahahahahah

:hehe:

Captain, Our Sensors are picking a strange energy level just outside the hull of the ship...

It would be a good idea to check if Snapshot Isolation is set to READ COMMITTED ON or OFF. Maybe in SQL 2005 set up you had, you might have...

I second Gails Motion. Please record it and post it somewhere where we the less fortunate can listen. 🙂

Glad to be of help. Now you can debug the issue much more efficiently. There are couple of articles written here in SqlServercentral.com itself that will help you with working...

Quite a few things to keep in mind when you are trying to estimate the space requirement.

What is your retention period?

Are you doing a Daily Back up?

What is the transaction...

You can run a profiler on the the Database to find out what Queries are executed.

Create this Login in SQL Server and give the Permission you need on the correct Database just like you give permission to a normal SQL User.

I have a feeling that quite a bit of your Stored Procs are compiled with out the "SET NOCOUNT ON" . This can eat up your Buffer Space. Restart will...

PF = Page File.

Communication Link Failure is something to do with the Network issues.