Restore Data from Transaction Log

How to Restore Database

Steps:

1.           Logon into SQL Server Management Studio.

2.           Right click on databases and Click on “Restore Database…”.

3.           Write Database Name “PromotionalExpenseDB” in “To Database” text box and then add latest Full database by selecting from “From device”. 

4.           Select database to restore.

 

 

5.           Select “Options” from select page pane.

 

6.           Select “RESTORE WITH NORECOVERY” through Recovery state radio button.

7.           The message appears.

 

8.           Now, restore latest differential database by right click on the “database” .

 

9.           Select Task --> Select Restore --> Database.

10.       Then follow steps 3-7.

11.       Then restore transaction logs which were backed up after the latest differential backup till last transaction log by following steps 8-10.

12.       For the last transaction log choose “RESTORE WITH RECOVERY’’ steps 5.

13.       The entire database restore process will be complete successfully.

SQL Full, Differential, Transaction log Backup

How to Change Simple Mode to Full Mode

In order to take a transaction log backup, you first need to check if the database is in Full Recovery model, if the database is in Simple Recovery model, you do not need to take transaction log backups.

Steps:

1.     Login into SQL Server Management Studio. 

2.     Right click on the database and choose Properties.

 

    3.     Select Option, Select Mode from Recovery model drop-down list.

 

  

How to schedule a backup

Steps:

1.     Logon into SQL Server Management Studio.

2.     Go to Management then Maintenance Plans.

    3.      Right click on Maintenance Plans and choose “Maintenance Plan    Wizard”.

  

4.     Click on Next to skip the introduction screen.

5. In the next menu, give a Name to the maintenance plan and also change the Schedule of the maintenance plan (how often the backup will be executed) by selecting single schedule for entire plan. Click on Next.

   6.  Then choose the actions that the Maintenance Plan will do. Here you select the option “Back Up Database (Full)”.
 

Optionally, you may want to also select the task called “Clean Up History”. This task deletes the history for old backup/restore operations. Or you may also select the task called “Maintenance Cleanup Task”, which deletes old text files that were produced by old maintenance plan executions.

7.     Then specify the Maintenance Task order (in what order the tasks will be executed).

8.    In the next menu, select the databases for which you want backup (Full) to be executed. Also select where you want to back up the database’s Full e.g. on a disk drive (on a specific folder) or on a tape drive. Be careful to specify an existing valid folder (if the folder does not already exist, you will get an error message). Also choose to verify backup integrity, to make sure the backup you captured is valid.

  

9.   In the next menu, choose the text files (the maintenance plan reports) that you want to delete. This menu will not appear if you had not previously selected the “Maintenance Cleanup Task” in step (6).

10.   In the next menu you define how old is the historical data you want to delete. If you haven’t selected the task “Clean Up History” in step (6) you will not see this menu.

11.   In the next menu, you can optionally choose to generate a report for this maintenance plan, for each time it is executed. Generating a report will help you identify any issues with the execution plan of the maintenance plans.

12.  In the next menu, you can review the actions you have already selected. Then by pressing “Finish” you create the Maintenance Plan.

13.  Follow steps 1-12 to create Maintenance Plans for Differential, Transaction log.

14.    Start SQL Server Agent.

User Guide for SharePoint Library

[How to login to site]

1.       Open Internet Browser (e.g. Internet Explorer).

2.       Type //dms/ in address bar. Press Enter key from Keyboard.

3.       Beximco Pharmaceuticals Ltd. e-library Index page appears.

4.       A window appears to request for  entering User Name & Password

5.       Type User Name (e.g test1) & Password (e.g. *****)

6.       Click OK button, you will be logged in into library automatically.

[How to create a folder]

7.       Click on Documents from ribbon. Documents’ menu appears.

8.       Click on Icon to create a folder. New Folder window appears (As figure below)

9.       Enter folder name (e.g. Test) in name text. Click Save button.

[How to create a folder inside a folder]

1.       Double on created folder (e.g. Test), then follow steps of [How to create a Folder]

[How to upload single/multiple file]

1.       Click on Documents from ribbon. Documents’ menu appears.

2.       Click on  Icon. Single & Multiple file upload link list appears.

3.       Click on Upload Multiple Documents link if you want to upload multiple file at the same time or Click on Upload Documents link if you want to upload single file. File will be uploaded automatically.

4.       If you click on Upload Documents link. The following window appears.

5.       Click Browse button to select the file from its stored location, write version comments if you want to.

6.       Click OK button, upload progress will be shown. Then appears window to write file properties like Title, Document type as follows.

7.       Click Save button. File will be Uploaded (If you upload multiple file at the same time, the properties information window will not appears).

For writing properties of uploaded multiple file, follow the below steps:

a.       Select single file by selecting file Type check box (As Figure).

b.      Click on Edit Properties from tool ribbon. Edit Properties window appears to write file properties information. 

[How to publish uploaded file]

After checking an uploaded file, you need to follow the below steps to publish a file for other users.

1.       Select single file by selecting file Type check box.

2.       Click on  Icon to publish a file.

Partial Test Report of SharePoint2010

 Case 10: Disable “Open in Windows Explorer” for everyone except site Owners.

Steps to be executed	Steps:          i.            Login into library with User name: ‘test1’ & password: ‘****’
Actual Result	Enable “Open in Windows Explorer” feature with test1 user permission label
Pass/Fail	Fail
Comments	On your SharePoint server go to the following folder and make a copy of the DefaultTemplates.ascx file. \Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\CONTROLTEMPLATES Rename the copy of DefaultTemplates.ascx to CustomDefalutTemplates.ascx Open CustomDefaultTemplates.ascx in Notepad and change the following line: ID=”OpenInExplorer” Change PermissionString=“UseClientIntegration” to PermissionString=”MangeWeb” Save the file Reset IIS

  

Case 9: Log-in to Library (unexpectedly problem occurs)

Steps to be executed	Steps:          i.            Login into library with User name: ‘test1’ & password: ‘****’
Actual Result	Access denied
Pass/Fail	Fail
Comments	Cannot connect to database (SQL database was stopped). Start SQL database. Restart IIS and SharePoint Server Finally, Server could establish connection between server and database. User could login to e-Document Library. The Problem has solved: PASS

 

Case 7: Different users for Different Library

Steps to be executed	Steps:                      I.            Login into library with User name: ‘test1’ & password: ‘****’
Actual Result	Can View others libraries’ link.
Pass/Fail	Fail
Comments	Go to library setting then Stop Inherit Permission then Grant permission the user:   PASS

 

Case 6: Multiple file Upload

Steps to be executed	Steps:                      I.            Login into library with User name: ‘Test1’ & password: ‘****’                     II.            Browse to Folder                   III.            Click Upload Document                   IV.            Click Upload Multiple Documents
Actual Result	Pop-up a download window.
Pass/Fail	Fail
Comments	Internet Download Manager (IDM) was blocked with the process. Uninstall IDM. The Problem has solved: PASS

 

 Case 5: Search Engine

Steps to be executed	Steps:                      I.            Login into library with User name: ‘test1’ & password: ‘****’                     II.            Browse to Home page                   III.            Type the file name in search text box and press Enter key from Keyboard.
Actual Result	Searched content did not find
Pass/Fail	Fail
Comments	The library database was not configured and engine was not connected with configured port. Fix those problem: PASS

  

Case 4: Permission for a specific file

Steps to be executed	Steps:                      I.            Login into library with User name: ‘test1’ & password: ‘****’                     II.            Browse the specific file
Actual Result	Single file appears in user’s home page
Pass/Fail	Pass
Comments	Stop inherits permission and grant permission for the specific file

Case 3: View file

Steps to be executed	Steps:                      I.            Login into library with User name: ‘test1’ & password: ‘****’                     II.            Browse Folder                   III.            Click on the file
Actual Result	Cannot view files
Pass/Fail	Failed
Comments	Uploaded file was not published. Published the files. The user can view the files: PASS

 

Case 2: Log-in

Steps to be executed	Steps:                      I.            Login into library with User name: ‘test1’ & password: ‘****’                     II.            Create folder from Document tab                   III.            Up-load a file under the folder
Actual Result	Cannot login into library with the permission level
Pass/Fail	Failed
Comments	Permission level was not granted in central administration. Fix the problem and execute the test plan with result : PASS

 

Case 1: Log-in

Steps to be executed	Steps:                      I.            Open Internet Explorer then type library URL in address bar                     II.            Login window appears. Type user name & password in user name & password text box.                   III.            Click Ok button.
Actual Result	Access Denied
Pass/Fail	Failed
Comments	User doesn’t have permission in root domain. Type till sub-domain of URL where the specific user has permission: PASS