Archive for the ‘Backup & Restore’ Category

Now It is at least 2 weeks that I found 2 kind of errors in my sharepoint server Event Viewer. yes, I solved them finally !! 🙂

The first one was :

Source : Office Sharepoint Server
Category : Office Server General
Event ID : 7888
Description :
A runtime exception was detected. Details follow.

Message: Cannot open database “DB Name” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITY\SYSTEM’.

The Second one :

Source : Windows Sharepoint Services 3
Category : Database
Event ID : 3760
Description :
SQL Database ‘DB Name’ on SQL Server instance ‘Server Instance’ not found. Additional error information from SQL Server is included below.
Cannot open database “DB Name” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITY\SYSTEM’.

The point was that I had deleted these databses before. There were some old sharepoint  RESTORE databases. These databases did not exist any more. I wondered a lot why sharepoint OWSTIMER attempt to connect to them. I searched a lot and finally found it is related to my content databases. yes, I think any Restore database, will add to the related web application as a content database.

However I had deleted the old databases manually from the SQL server management Studio, but the name of databases had remained in the Central Administration. I found them in the Application Management > Content Databases . So after Checked the Remove content database and push OK , there were no more errors in the event viewer.
I think we for deleting any content content database, it’s better to use this way instead of manually deleting it from SQL management studio.

Good luck !

It was long time that I have a question in my mind 

How can I schedule a backup of my server farm ?! and another one that  How can I Restore per file ?! I searched a lot and found there’s no pre defined solution in microsoft sharepoint itself. Also there are some applications that can solve it but I didn’t want to use them . I found a good post that I think it’s a nice trick to backup sharepoint and restore your file !

The trick in summary was that you should schedule your backup jobs and after that , when a restore a file was needed, you restore the whole backup in a temp location and use your file ! So how to do it ?!

1 – Go to  Control Panel –> Scheduled Tasks –> Add Scheduled Task

2 – Browse to the the folder that “Stsadm.exe” exists and select it. you know :
(  %SystemDrive%\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Bin )

3 – in the next 3 dialog you should set how often you want to run the task ( daily and timely ). it’s up to you but if the existence of files is very important I think it’s good to do your backup daily .

4 – after you entered your administrator credentials click Next.

5 – Select the “Open advanced properties when you click finish” check box, and then click Finish”.

6 – Then in the Run Section type the exact address of stsadm.exe and type your backup command for example in my case it is :  C:\Program files\Common files\Microsoft shared\Web server extensions\12 Bin\Stsadm.exe” -o backup -url http://yourCompanyweb -filename SPBackup -directory “local or UNC path” -backupmethod “Full/Diffrential”

you can find more details on backup command on microsoft technet here . I found this way in this blog and I’m very thankful to Bradly.