World Computer Security Day

Computer security is the process of preventing and detecting unauthorized use of your computer. Prevention measures help you to stop unauthorized users  from accessing any part of your computer system. Detection helps you to determine whether or not someone attempted to break into your system, if they were successful, and what they may have done.

Protect your hardware:
Safety and security start with protecting computers. Install a security suite (antivirus, antispyware, and firewall) that is set to update automatically. Keep your operating system, Web browser, and other software current as well and back up computer files on a regular basis.

Use strong passwords:
Make sure that your password is long, complex and combines, letters, numerals, and symbols. Ideally, you should use a different password for every online account you have. If you need to write down your password to remember it, store it somewhere away from your computer.

Email:
Before opening any email attachments, be sure you know the source of the attachment. It is not enough that the mail originated from an address you recognize. The Melissa virus spread precisely because it originated from a familiar address. Malicious code might be distributed in amusing or enticing programs.

Keep personal info personal:
Be cautious about how much personal information you provide on social networking sites. The more information you post, the easier it may be for a hacker or someone else to use that information to steal your identity, access your data, or commit other crimes such as stalking.

Scheduling Backups for SQL Server 2005 Express Edition

One drawback with SQL Server 2005 Express Edition is that it does not offer a way to schedule jobs. A database backup in SQL2005 Express Edition is scheduled in both the operating system and SQL Server using the tools.

To schedule a backup of a database:

Steps :

1.    Create a folder ‘BackUp’ in D drive, “D:\Backup“.  ( This can be changed to any folder you like.)

2.    Go to Start>>Programs >>Microsoft Server 2005>>SQL Server Management Studio, Click SQL Server Management Studio. Microsoft Server Management Studio window with Connect to Server dialog box appears (see Figure 1).

Figure1

3.    Enter a password of the server in Password field.

4.    Click Connect. It connects to the database server and Microsoft Server Management Studio window refreshes (see Figure 2).

Figure2

5.    Expand Databases sub folder (see Figure 3).

Figure3

6.    Expand ‘master’ sub folder.

7.    Click   New Query. A new query file opens ( Figure 4 )

Figure4
USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_BackupDatabase] Script Date: 26/11/2010 11:40:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[sp_BackupDatabase]
@databaseName sysname, @backupType CHAR(1)
AS
BEGIN
SET NOCOUNT ON;

DECLARE @sqlCommand NVARCHAR(1000)
DECLARE @dateTime NVARCHAR(20)

SELECT @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') +
REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','')

IF @backupType = 'F'
SET @sqlCommand = 'BACKUP DATABASE ' + @databaseName +
' TO DISK = ''D:\Backup\' + @databaseName + '_Full_' + @dateTime + '.BAK'''



EXECUTE sp_executesql @sqlCommand
END

8.    Click   to execute the query. It saves the query in the name highlighted in red (see Figure 5) in Stored Procedures sub folder.

Figure5

9.    Click   New Query. A new query file opens.

10.    Type the following query in the new query file.

sp_BackupDatabase ‘readydesk’, ‘F’
GO
sp_BackupDatabase ‘abacus’, ‘F’
GO
QUIT

11.    Place the cursor at the top of the query.

12.    Right-click the mouse. A shortcut menu appears (see Figure 6).

Figure6

13.   Save the file as backup.sql and for our purposes this is created in the “D:\Backup” folder, but again this could be put anywhere.

14.    Goto Start>>Programs >>Accessories>>System Tools>>Scheduled Tasks, click Scheduled Tasks. Scheduled Tasks window appears (see Figure 7).

Figure7

15.    Click ‘Add Scheduled Task’. Scheduled Task Wizard screen appears (see Figure 8).

Figure8

16.    Click Next. Scheduled Task Wizard screen refreshes (see Figure 9).

Figure9

17.    Click ‘Browse’ to SQLCMD.EXE. Select Program to Schedule screen appears (see Figure 10).

Figure10

18.    Browse to select ‘SQLCMD.EXE’ in the programs.

“C:\Program Files\Microsoft SQL Server\90\Tools\Binn”

19.    Click Open. It adds the selected program to the Programs list.

20.    Click Next. Scheduled Task Wizard screen refreshes (see Figure 11).

Figure11

21.    Type the name of the task in Task field.

22.    Click ‘Daily’.

23.    Click Next. Scheduled Task Wizard screen refreshes (see Figure 12).

Figure12

24.    Specify the time to run the task.

25.    Click Next. Scheduled Task Wizard screen refreshes (see Figure 13).

Figure13

26.    Type the credentials of the account such as user name, password and confirm password in respective fields.

27.    Click Next. Scheduled Task Wizard screen refreshes (see Figure 14).

Figure14

28.    Check ‘Open advanced properties for this task when U click Finish

29.    Click. Finish. Database Backups window appears (see Figure 15).

Figure15

30.    Type the command ‘sqlcmd -S serverName -E -i D:\Backup\Backup.sql’ in Run field.

Note: SQL query is denoted as follows:
o    Sqlcmd
o    –S: It defines the server\instance name for SQL Server.
o    serverName: It specifies the server\instance name for SQL Server. For instance,  WS076\SQLEXPRESS\
o    –E: It allows you to make a trusted connection.
o    –i: It states this specifies the input command file.
o    D:\Backup\Backup.sql: It specifies the path of the backup.sql file.

31.    Enter the user name in Run as field.

32.     Click Apply.
33.    Click OK. The database backup is scheduled.
34.    Select ‘Database Backups’ scheduled task in Scheduled Tasks window.
35.    Right-click the mouse. A short-cut menu appears (see Figure 16).

Figure16

36.    Click Run. It runs the task at the scheduled time.


SQL2005 Database Restore Procedure

To restore a backup of a database:

Steps :

1.    Go to Start>>Programs >>Microsoft Server 2005>>SQL Server Management Studio, Click SQL Server Management Studio. Microsoft Server Management Studio window with Connect to Server dialog box appears (see Figure 1).

Figure 1

2.    Enter a password of the server in Password field.

3.    Click Connect. It connects to the database server and Microsoft Server Management Studio window refreshes (see Figure 2).

Figure 2

4.    Expand Databases subfolder under Test_Server\SQLExpress folder (see Figure 3).

Figure 3

5.    Right-click a database that you want to take a restore backup. A shortcut menu appears (see Figure 11).

Figure 11

6.    Click Tasks>>Restore>>DatabaseRestore Database dialog box appears (see Figure 12) displaying the selected database in To database list.

Figure 12

7.    Click … button beside From device field. Specify Backup dialog box appears (see Figure 13).

Figure 13

8.    Click Add. Locate Backup File dialog box appears (see Figure 14).

Figure 14

9.    Browse to select a backup file.

10.    Click OK. Specify Backup dialog box refreshes (see Figure 15) displaying the selected backup file in Backup Location list.

Figure 15

11.    Click OK. Restore Database dialog box refreshes (see Figure 16) displaying the selected backup file path with file name in From device field.

Figure 16

12.    Select ‘Restore checkmark’ option marked in red colour.

13.    Click Options in Select a page section in Restore Database dialog box. Restore Options dialog box appears (see Figure 17).

Figure 17

14.    Check ‘Overwrite the existing database’ option.

15.    Click … buttons in Restore the database files list to select the backup file path with file name.

16.    Click OK. A message appears (see Figure 18) to a user for confirmation after completing the restoring of the database backup file.

Figure 18

Source: Microsoft

SQL2005 Database Backup Procedure

Do the following tasks to take a backup of a database:

Steps :

1.    Go to Start>>Programs >>Microsoft Server 2005>>SQL Server Management Studio, Click SQL Server Management Studio. Microsoft Server Management Studio window with Connect to Server dialog box appears (see Figure 1).

Figure 1

2.    Enter a password of the server in Password field.

3.    Click Connect. It connects to the database server and Microsoft Server Management Studio window refreshes (see Figure 2).

Figure 2

4.    Expand Databases subfolder under Test_Server\SQLExpress folder (see Figure 3).

Figure 3

5.    Right-click a database that you want to take a backup. A shortcut menu appears (see Figure 4).

Figure 4

6.    Click Tasks>>Back Up.. Back Up Database dialog box appears (see Figure 5) displaying the selected database in Database list.

Figure 5

7.    Click Add in Destination section. Select Backup Destination dialog box appears (see Figure 6).

Figure 6

8.    Click … button beside File name field. Locate Database Files dialog box appears (see Figure 7).

Figure7

9.    Browse to select a path.

10.    Enter file name in File name field.

11.      Click OK. Select Backup Destination dialog box refreshes (see Figure 8) displaying the selected path in File name field.

Figure 8

12.    Click OK. Back Up Database dialog box refreshes (see Figure 9) displaying the selected backup path in Destination list.

Figure9

13.    Click OK. A message appears (see Figure 10) to a user for confirmation after completing the backup of database successfully.

Figure 10

Source: Microsoft

World Hello Day (November 21)

Bonjour! ¡Hola! Ciao! Hallo! Olá! Konnichiha… Hello

The salutation is so commonplace but a pleasant greeting can brighten someone’s day. World Hello Day was created in 1973 because of the raging quarrels between Egypt and Israel; world leaders wanted to manifest the magnitude of choosing communication rather than force in order to handle conflicts.

Can you even imagine what the world would be like if people used negotiation and intellectually driven conversation in order to solve their conflicts rather than violence or force?