OK, thanks for posting back. Turns out that you were specifying the same physical file twice in the same RESTORE statement.

John

forever20xx (5/17/2012)

---

I tried to take a backup locally on the D Drive itself and that worked like a charm. Is there a way around this. Because I am sure the...

The plot thickens. I followed the link that Dwain posted but there was nothing in the terms and conditions about stored procedures.

I shudder to imagine how you go about...

Well, that isn't the only resource available. I'm sure your search engine works just as well as mine does.

Are you using a format file? That's the way to...

That's interesting. What exactly are BT hosting? Is it the database? Is it a database that you wrote, or one that they have provided for you? ...

There's tons of information about this on the web. Here's an example:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/10/04/bcp-bulk-insert-format-file-escape-a-quote-more-to-the-point-loading-quoted-csv.aspx

John

I'm staggered. How can it be more secure to have to grant access to all tables and views for querying, instead of just execute permission on the stored procedures?...

If that works for you, then that's the simplest thing to do and you should keep doing it. But rebuilding indexes can cause significant log file activity and so...

MySQL isn't exactly the same as SQL Server, I'm afraid. You'll need to get a more appropriate book, or find some way of translating MySQL code into T-SQL.

I still...

See that error number 64? If you go to a command prompt and type net helpmsg 64, you'll get a description of what the error means. In this...

One thing you could try, depending on how often you rebuild your indexes, is to stop the log shipping jobs before the rebuild starts, then restore the whole database on...

Are you sure the database is SQL Server? That query has a few pieces of syntax that I don't recognise. Just as a matter of interest, why and...

Please start a new thread. People are less likely to be looking at a seven-year old topic than a new one.

John

That isn't an error, it's a CREATE DATABASE statement. Is that what you get when you press the Script button in the Restore Database window? No RESTORE statement?

Now,...

So are you saying that if you look on the disk, the file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\BGPhoenix.mdf doesn't exist? If that's the case, then I imagine you're trying to...