Can you check this link.

http://support.microsoft.com/kb/314520

Can you verify the checklist here.

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

Other editions can read the compressed backup. It should work. Have you tried to restore ?

Is it not partitioned?

I do not think partition can server your purpose. Can you share some details here to see whether we have something to propose.

1. How much database size?

2. How much the...

Is there a way to use SSIS?

So I shall go ahead with 2nd plan? Should I consider the cpu time (more than first one) as well? I am testing it in Dev , have no idea...

No preference with tempdb files per core ration, until we face tempdb bottleneck. Usually it would start with Latch waits for allocation contention.

Take a sql backup of system database. Try to restore them in another instance with different database name.

Then deattach and copy the mdf, ldf file.

But I did not test this....

John +222

If you have fixed port(other than 1433) and be able to hard code in apps, then sql browser is not necessary for this application.

foxxo (6/25/2013)

---

I think he is saying his instance is not listening on 1433 (which is the default, instances are a non default port). If it's hard coded, it's bypassing...

http://msdn.microsoft.com/en-us/library/aa173909(v=sql.80).aspx

You have some transaction which uses T log. I would suggest SQL TRACE to see how much WRITEs each batch is taking. So that we can see what is happening...

See if this url helps you.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/73fb15c0-9270-4cbf-a74e-544639e792da/error-1418-fails-to-connect-mirror-server

Note down the service account your sql agent running.

then Right click the folder your trn backup files are there -> security tab-> check there if account has Full...