No Orphan users - tried that earlier...

Server name is different. We changed that in the application. Bu the same application is working fine for Server 1. But for server 2...

Toby,

T-SQL - given be you..

Can this be used to make this to run alternate days.. In a JOB, so that it can script the objects without data.

Thanks much Toby,

Yeah i need to script Schema as well..

Sorry did not posted.

Reboot the machine if Possible - this will resolve many issues. (Production)

If not. Then stop the services of SQL Server and Agent services and try starting the services ...

I faced...

Database is never backedup till date. Its a DEV server. So planned to perform a backup

Database compatibility - 80 (all the dbs - simple).

Disk is fine, as the database files...

If it is 2 GB RAM then you can upgrade memory hope so.

PAE :

Please go through -- http://support.microsoft.com/kb/283037

http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx

on what basis, you say so ?

Its a best practise to have a perfromance..

-Win.

Good one rakesh... 🙂

Why there is - "There is 1GB memmory allocated to SQL Server." If you have excess memory you can increase based on the requirement. Recommended is 2GB must for OS.

Try...

Domain Change:

1. Services running under domain account should be changed

2. Check the report server and sharepoint if you are working

3. Script out the Logins of the servers you are moving...

Drop full text catalogs if not required, then perform a backup.

It should help.

Agreed..

I was talking about only SQL Express edition.

Windows server is the option we can use, as Gail said.

- Win.

You cannot automate database backups using Express Edition as you cant find SQL server Agent to create or schedule.

Check the disk space on both the servers.

Check if the mirroring is sync with the Mirror DB by monitoring.

http://msdn.microsoft.com/en-us/library/ms365786.aspx

Post the error you are facing. Check the event...

Yes.

However, if you allocate 2GB memory for CPU then it will be advisable..