It doesn’t matter if you’ll change the database’s name before or after the upgrade, but why do you want to change the database’s name? If you’ll change the databases’...

There are few ways. If you want to run it as a job you can use the same script in different steps and run each step in a different...

I never used the copy database wizard, so I can’t comment about it. Detach/attach is faster then backup and restore, but it causes down time on the original server....

If you want to check all databases, you can specify NULL as the value for all parameters. However I wouldn’t do that. If you want to check the...

Actually the mssqlsystemresource was introduced at SQL Server 2005

Adi

Thank you for the information. I’m sure that it will help someone else that will encounter the same problem.

Adi

Can you explain what are you trying to do? If the database was in simple mode, then there is no reason to truncate the log. If you modified...

How do you run the backup? What is the error message?

Adi

You need to decide how much data you can afford to loose and according to that decide on your backup policy. Depending on the requirements you can use other...

It is better that you’ll answer Steve’s question because there is a good chance that you are not on the right track at all. As I wrote before there...

It is very hard to understand the output of dbcc log or fn_dblog. Some might say that it is impossible:-). Although there is no much information available on...

I’m sorry but I’m not sure that I understand you. Are you running the BCP as part of distributed transaction? I don’t think that you can do it....

Yes there is, but it is undocumented. You don't have to take my word for it, you can just try run...

Can you provide the error that you are getting? It would be helpful when anyone tries to find the error. In any case I think you should also...

If you didn’t use Unicode and you also didn’t use collation that supports working with Arabic as Ascii character,...