SQL server files/programs vanished

60 pts.
Tags:
Data backup and recovery
Disaster Recovery
SQL Backup
Windows
Windows Server 2003
Windows Server 2003 Enterprise Edition
have domain server and sql server on network,  each backs each other up. users cannot access files on sql and some things seems to be missing on domain as well.  Older restore won't work, it states that files unavailable. I backed up everything I could on ext. hd's and am attempting to restore locally from them.  any ideas what would cause this?  looking for a start point from an experienced pro,  (I am basically workstation help desk but have to figure this out myself due to cutbacks). thanks

Software/Hardware used:
server 03 ent,

Answer Wiki

Thanks. We'll let you know when a new response is added.

How are you backing up the SQL Server’s databases? Are you using the BACKUP DATABASE command or are you just copying the files from the SQL Server to the other server?

What are you using to backup the server’s files to the other machine?

If you are just copying the SQL database files that isn’t going to do anything for you. You need to use the BACKUP DATABASE T/SQL command to backup the databases to disk, then move those files to the other server.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Hi Uwantfries, You will need to provide much more details if you really want to get some useful response. What exactly do you mean by "each backs each other up" ? how do they back each other up ? What do you mean by "users cannot access files on sql" ? Users don't access files on Sql Server. Sql Server's files are used by the DBMS only. "some things seems to be missing on domain as well": What kind of things ? "I backed up everything I could on ext. hd's": what exactly does that backup include ? how are you trying to restore it ? what software are you using ? What are the exact error messages or problems you are finding ?
    69,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following