Thanks for the nice explanation.

How about the issue of licensing? If I have many databases in one instance, I guess I have to pay licence fee for a single use?

If...

Hi,

I tried to install sql server 2005 on windows server 2008, but my first trial failed. From your message, I understand that you managed to run sql server 2005 on...

Thanks indeed.

In fact our organisation has several branches or so to say regional offices. At each regional office, we have been running MSDE or MS SQL Server 2005 express edition....

Thanks for your information. However, I was still wondering whether or not MS SQL Server 2005 enterprise or standard eddition was tested under Windows Server 2008, 64-bit. In other words,...

Hi Binyo,

Thaks for your hint. I will give it a try.

Regards

Niyala

Hi,

Thanks for your detailed explanation. I checked out the recovery model and it was set to simple recovery model. In addition, there is no backup of transaction log file. The...

Thanks a lot.

Both servers are in the network, and I can connect to the SQL database engine of one server to the other and vice versa. Therefore, I am not...

You are right. The backup and restore is the most straight forward way to go.

Niyala

Thanks a lot. In fact I intended to skip the part which executes the job, but I could not see options that enable to exclude. All I did was the...

Thanks a lot. Your information was very helpful.

Regards

Niyala

Thanks a lot. Backup and restore works well to do the job. However, why the copy database's last step (start sql server agent job) fails keeps me busy. Is there...

Many thanks indeed! I will work on your suggestions and see what suits most to my situation.

Your suggestions are very good and will help me work on the detalis.

Niyala

1) Do you have the appropriate permissions for both the source and destination servers?

Yes of course. I have permissions to both. I am a member of

sysadmin, therefore, the question...

Thanks. If fact I am trying to avoid downtime. That is why I chose the wizard. Further, I can schedule the wizard.

The error report I found in the error log...

Thanks for your information, I could sort out the problem of modifying the table in question. However, I am still trying to solve the following issue:

A colleague migrated the original...