Hope so, i would have googled correctly...

Still trying to...

How ever thanks for the reply. Any one who can suggest me on this..?

If you are trying provide / create access to the users on SQL the you have to create LOGIN and map the users to the databases.

Create login > User Mappings...

Just an add:

If you are trying to move only the backup files/folders you can use ROBOCOPY tool or simply you can use XCOPY from command prompt. Which move faster than...

Yes, its correct.

Taking 10 mins for backing up of 13GB is a normal and expected time. Dont worry about that, its working smoothly.

- Win.

suggestions required.

Please post your comments.

Ok.

So the JOB step failed right ?

if so check the JOBsteps perfectly or recreate again..

Correct.

If we have SP2 installed we dont require enabling trace flag 1400....

Check the SQL Logs and event logs for more info...

Try to do manual backup - Trans Log , and check if that works successfully.

Post the sql logs here..

You have to follow sequence in configuring the SQL Server Database Mirroring.

Full backup,

Trans backup,

Restore full backup on secondary with NORECOVERY,

Rectore Trans log backup on secondary with NORECOVERY,

Enable Trace flag ;-T1400,

end...

You mean to say that on one Publisher (DB) you have 5 Subscribers configured. ?

Well, if that is the case the replication will fail to that subscriber...

Check the Replication monitor...

I think you should Move the data into the file system and have reference to it in the DB

----------------------------------------------------------------------------------------------------

Thanks for the reply. This is what am looking for. Could you...

Any faced the situation. ?

Any thoughts..

Please provide your thoughts and suggestions.

Fast help is appreciated.

Hi,

We store in XML datatype. Any ideas and suggestions.

Thanks for the reply posted. I have some questions in my mind and need some clarifications.

I appreciated if someone points to me to better direction.

The size of the table is...