Ah, well, you've just gone past my knowledge of the topic.

Good luck.

Sounds like a permissions issue. Backups don't run under your security context, but under that of SQL Server. Make sure that SQL Server is running as a network login instead...

We restore across the network all the time.

RESTORE DATABASE x

FROM DISK = '\\server\sharename'

WITH REPLACE

Works great. Well, assuming the network is working correctly, hops across domains cause it to run very...

After wrestling with all the work-arounds (and losing) we finally settled on forwarding all events from our clustered servers to a non-clustered server where we have mail nicely, safely, reliably...

Everything the last post said and...

Statistics aren't generated for table variables so their use in queries can, depending on their size, cause performance problems.

I had to all but reformat my drive in order to get the June CTP installed. You will need to, at the least, uninstall the April CTP first.

Do you get an error, or just a blank screen? I ask because I've been getting network packet size errors when trying to connect and found that there's apparently an...

I don't think it installs a full version of VS. I got VS as a seperate install and did that on top of the SQL Server install and then had...

I don't know the answer to this question, but it intrigued me so I did a quick experiment. I ran this query:

select

o.name

True. And, assuming you're only going to run the scripts and then drop the linked server, it's not that big a deal. However, it is a bad practice from a...

Permissions on that proc are set to 'public', so it should work. Can you see it in the master database?

This worked fine when I tested it locally:

declare @sql nvarchar(2000)

set @sql...

I wouldn't add a linked server to production due to the security concerns that could raise.

Otherwise, the cursor option above or maybe an app that uses SQLDMO. DBArtisan will allow...

Honest answer... It depends.

However, if your query is taking 10 minutes, I'd examine exactly what it is that you're doing as far as the basic process goes. Are you moving...

We have an emergency response team that practices recoveries from various issues once a month. Almost all them involves restoring to a point in time. There's nothing worse than have...

One thing not mentioned in the article, if possible, take one more log backup. If not possible, you may lose 9 minutes worth of data.