Thanks for all your posts, SKYBVI i am running the restore script on serverb - the server i want the database to be restored to not where it is backed...

Thank you!.... it now looks like the account i am using does not have enough permissions on the account to access the directory.

Can you confirm this please?

Msg 5133, Level...

Thanks guys i have now posted a new thread. I'd be thankful i you could tell me how to close this one off now please?:-D

Ys that probably would have been a good idea, how can i do that?

My results for the following statement:

RESTORE FILELISTONLY

from disk = 'c:\sqlbackups\testdb.bak'

testdb_DataC:\Program Files\Microsoft SQL Server\MSSQL\data\testdb_Data.MDFDPRIMARY104857635184372080640

testdb_LogC:\Program Files\Microsoft SQL Server\MSSQL\data\testdb_Log.LDFLNULL104857635184372080640

Hi, i have been trying to do a similar task. I am hoping to restore the backup file from serverA to serverB.

When i run the script the following error...

Hi, apologies for my late response to your additional advice.

Grant, I think you're right about learning about Powershell and sql restore being a daunting task. I really want to...

Hi All, thanks for your replies, they are much appreciated.

There is a backup schedule on the 2000 server, and it is here i want to setup a job to copy...

Unfortuntely not:( i've been scanning the error logs and event viewer for days now and there isnt anything that stands out. I can't restart the server as there are other...

Hi i tried the sql agent and it didnt work. The same error message has appeared.

Do you have any other advice?

TIA

Thanks...

Hi Kiran, yes there was, but i have moved them to a later time now. Yet the error is still occuring.

Thanks for you post.

I can do that, but, what benefits will restarting the sql agent have on connections to that server?

TIA

No SP's or patch's. The mystery of this is the other database's on the same server are not being affected.

TIA

Hi All, i too have found that some of the databases i monitor have no space available in the properties window. I ran the script Manu-J and it provides the...

Hi All, I'm a trainee dba and have been asked to do something very similar here whereby the email address in a table has to be changed from the "at"...