SQL server files/programs vanished
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,
Software/Hardware used:
server 03 ent,
ASKED:
September 13, 2010 7:19 PM
UPDATED:
September 15, 2010 1:33 AM
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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 ?