Thanks Steve for your immediate response 🙂

I understood point #2..It will be great if #1 is also made possible..

Hello,

Just an update: I read the below thread and came to know that it is possible to perform the upgrade from Sql Server evaluation edition to Standard edition without the...

You can make use of this command to restore the database,

(a) RESTORE FILELISTONLY FROM DISK='D:\YourBackupfilename.bak'

GO

(b) RESTORE DATABASE NewDatabaseName

FROM DISK='D:\YourBackupfilename.bak'

WITH MOVE'LOgiclaName...

As mentioned above, if you have witness server it will automatically perform the failover to the mirror server if the principal server is down. In your case since you don't...

Sql Server seldom requires to be restarted. Only if your tempdb grows abnormally and fills the disk space you can restart it to recreate tempdb and free the disk space....

Check if this link helps which recommends you to apply latest service pack for XP, http://support.microsoft.com/kb/867783

You can upgrade from Sql Server 2005 trial edition to Sql 2005 enterprise edition without uninstalling. Refer this article for performing the same,

http://sql-articles.com/index.php?page=articles/eval2entupgrage.html

But for performing the upgrade from...

Sql_lvr (5/11/2008)

---

I installed SQL Server 2005 enterprise edition. After the installation, I did not get Management Studio installed. To make matters worse, I now get pop-up telling me my SQL...

I think Sql Server is having a case-sensitive collation and hence the above error message. You can confirm this by runnning,

sp_helpsort (or) SELECT SERVERPROPERTY ('Collation')

It seems that you have killed a process so please wait for some time and see if the rollback completes. Its always good to use,

Kill Spid WITH STATUSONLY option because...

You can perform the following,

1. After restoring if there is any mismatch ids (there might be some) you need to make use of sp_change_users_login procedure to map the login to...

Are you able to connect to Sql Server 2005 remotely i.e have you enabled remote connections please confirm..

before running the above command please change the database context to master using the below command,

Use MASTER

now try to once again run the command I mentioned in my earlier...

You need to mention the logical file name i.e PBFamily_Data and

PBFamily_Log. I have modified the script please try with this one and let me know if thats good to...

You cannot perform log shipping from Sql Server 2000 to Sql Server 2005 and hence that option is ruled out. Refer the below link where similar topic was discussed few...