Home > IT Answers > Storage > SQL server files/programs vanished
Uwantfries
55 pts.
 SQL server files/programs vanished
Disaster Recovery, Windows Server 2003 Enterprise Edition, Windows Server 2003, Windows, Data backup and recovery, SQL Backup
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,
ASKED: Sep 13, 2010  7:19 PM GMT
UPDATED: September 15, 2010  1:33:42 AM GMT
RELATED QUESTIONS
Mrdenny
63,630 pts.
Answer Wiki:
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.
Last Wiki Answer Submitted:  Sep 15, 2010  1:33 AM (GMT)  by  Mrdenny   63,630 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

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 ?

Carlosdl
 60,255 pts.