If the Windows account is already exist on your system, then you can use the above script to add it to SQL Server, and assign the required permissions.

Hello Robert,

I'm wondering if it's safe to open firewall ports to enable database mirroring. Even if you allow specific host, allowing it to traverse the Internet is quite scary....

It means you logged on to your PC with the user account...

rishitha (8/4/2010)

---

Hi all,

i need your help to do database mirroring for my two servers.

principal database which i am going to use is already acting as a publisher in the replication.

for...

You can not create a Windows Login account using the above script. You need to create the Windows Account using Computer Management (Start --> Run --> Compmgmt.msc).

Expand Users &...

You actually need two credentials, one to connect to the SQL Server instance (Login) and one to connect to the database (User).

If you are using Windows Authentication to connect to...

Sorry Ravi, still, I am not very sure whether I understand the requirement properly.

You initiate a backup for your database, and stored the backup file to a specific location. When...

Ravi,

I didn't understand your problem correctly, You want to perform a backup or you want to restore from a backup file?

Shrinking of database is not recomended.

If you don't have log backup in place, it is a good idea to change the recovery model of the database to Simple. However, you...

This is not advisable, Tuncating the log will not solve the issue.

A transaction log...

SQL Server SP 3 is a contains all the previous changes of SP1 and SP2. If you don't have any application compatibility issue, then you can directly apply SP3.

Take a...

I am not a developer, however, I understand that you need to provide the name of your mirror instance in your configuration file. If you are connection with ADO.NET, I...

You have already mentioned that Database is in Full recovery model; however, you don't have a log backup. You need to understand that only transaction log backup provides point-in-time recovery,...

Create a job on the ERP server to create a backup of the database and move the backup file to the test machine. Your SQL Server Agent account should have...

No, since both are in the same domain, you can configured it without certificate.

Follow the steps from the article, I don't think you will have any issue during configuration.