Sorry, but this isn't clear - are you running x64 or x86 versions of the OS and SQL Server?

Run the following in a query window on both servers: SELECT @@VERSION

If...

mike 57299 (5/21/2010)

---

Lamprey13 (5/21/2010)

---

I'm not sure if that is possible. But, even if it is possible, that sounds like a really bad idea.

Have you investigated using a "listener" app that...

How are you determining that the SP isn't using any memory? Does the procedure execute and return the desired results? Does it take less/more time than on the...

That kind of question is very subjective - you'd have to define the term 'best' before you could even begin to answer the question.

Even for a low transaction system, what...

I have read through this multiple times now, and I don't see where you state what the actual error is. What error are you getting?

As others have said -...

What do you mean it doesn't work? Do you get an error message?

If the user running SQL Server is the local system account, then that user has access to the folders on that server that it has been granted access to. ...

You have to install SP3 first - then install CU4, and finally - you have to modify the startup to include the trace flag according to that article.

To your second...

CirquedeSQLeil (5/21/2010)

---

Be careful on the processors. You may have 8 processors but only 2 sockets. Licensing is based on socket.

Otherwise, developer edition can be used on any non-production...

When you are running the restore command - you are also accessing the database. Change the database context to a different database and reissue the command.

This seems like a perfect fit for synonyms....

So, you cannot lock pages in memory unless you have installed SP3 and at least CU4 - and I believe you also have to use a trace flag when starting...

No - you can't script the maintenance plans, at least I am not aware of any way to do this.

With that said, there is a way you can export/import the...

Are you running SQL Server standard edition or enterprise? You should uprade to sp2 cu4 or later if running standard

It really depends upon which VLF is the active one. If the active VLF is somewhere in the middle of the file, performing a log backup just moves to...