Skip to main content

Posts

Solution for SQL Database Backup Restore Error

Sql Error Description Facing Below Error during Restoring of SQL Database to existing database or newly created database. Restore of database 'MicrosoftDynamicsAx' failed. (  Microsoft.SqlServer.Management.RelationalEngineTasks) System.Data.SqlClient.SqlError: BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.SmoExtended) Solution : This Error due to you have take Full SQL Backup in Read only mode. To solve this issue you can try below steps. 1.U ntick tail log backup checkbox .If you don't know about Tail log backup option then search on google to know more about tail log backup. 2. Second option is you can take full backup of database again then restore then file on database then you can deleted backed up file to free the disk space.

Intranet and Extranet,Artificial Neural Networks,Server and Workstation

Intranet and Extra net An Intranet is a private network (LAN) that uses the TCP/IP protocol suite. However, access to the network is limited only to the users inside the organization. The network uses application programs defined for the global Internet such as HTTP, and may have web servers, print servers, file servers etc. Extra net Private network that uses the Internet protocol and the public telecommunication system Shares part of a business's information with suppliers, vendors, partners, customers or other businesses. Viewed as part of a company's intranet that is extended to users outside the company. Artificial Neural Networks ARTIFICIAL NEURAL NETWORKS •Neural Networks can supplement the enormous potential of traditional computers with the ability to make sensible decisions and to learn by experience. •Neural Computation is done by a dense mesh of computing nodes and connections. They operate collectively and simultaneously on data inputs....

Structured query language,SQL Query Processing

Structured query language The common commands and methods used in it are grouped into the following categories: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Logical Connectors, Comparison operators, Aggregate functions, Joins, Sub query, Relational operators, Where clause etc. Data definition language covers SQL commands that create and destroy database tables. Data manipulation language covers SQL commands that create, change or destroy the information in a database table or the structure of the table. Data control language covers protection to the database such as granting access to the tables. Comparison operators cover those operators that allow for comparison between two items. Aggregate function deals with those standard SQL functions that allow programmers to narrow the search of a database. Joins category covers those items that allow information from two or more tables to be related. SQL Query Processing ...

Limitations of computer,Introduction of Internet

Limitations of computer 1. No Feelings: Computers are not living. Hence, can’t make judgment of its own. Its instructions are based on information given to it in form of program. 2. It is Dumb: Computer posses no intelligence of it’s own. It’s I.Q. is zero. Computer can’t take it’s own decision in this regard. Definition of  Internet Internet is a worldwide network that provides an infrastructure to connect universities, government offices, companies, students, scientists, researchers and private individuals. A machine to be on the Internet means it runs TCP/IP protocol stack, has an IP address, and has the ability to send IP packets to all the other machines on the Internet. A private individual having a personal computer can call up an Internet service provider using a modem, be assigned a temporary IP address, and send IP packets to other Internet hosts.  An Internet consists of a set of connected networks that act as an integrated whole. The Internet provides ...

Application Domain,Definition of SQL Server Integration Service(SSIS).

Application Domain Application domain is nothing but a process(not exactly as normal process) where the application will be running on it. Application domain will isolates all the applications by running each application in a diff. app domain. For instance, if 5 applications are running on your system, it will then creates 5 diff app domain to guarantee the security. It also has the following advantages, 1. An application can be independently stopped. 2. An application cannot directly access code or resources in another application. 3. A fault in an application cannot affect other applications. Definition of SQL Server Integration Service(SSIS). SQL Server Integration Services (SSIS) is one of the main issues of Microsoft BI (Business Intelligence) concept representing the data integration and data transformation in the enterprise level approach. SSIS (SQL Server Integration Services) has the ability to gather data from various resources in different kinds of formats, p...

SQL Tips-Bulk insert records into table ,Select into ,Insert into,delete record in chunks,Remove unused space

Bulk insert records into table in sql  This is the way to Bulk insert records into table in sql or oracle insert into  If you want to insert of table data to existing table then you need to select insert into query. E.g. INSERT   INTO   Table2 SELECT   *  FROM   Table1 insert into dTable select * from sTable It mean table2 and table1 both exists before execution of query and its simply insert data line by line. It takes more time on execution. Select into: If you want to copy of table structure with data to new table then you need to select select into query. E.g. Select * into tab1 from tab2. It means tab2 exists and tab1 does not exist in database before execution of query. After execution it will copy data of tab2 to tab1 and it will create table tab1 also. if dTable is blank and doesn't have any record. Create this as follows: definately reduce the time. CREATE TABLE dtable NOLOGGING AS SELECT * FROM stable Exa...

Command to know the incoming network connections,transmitting data to server in unix

Command   to know the incoming network connections in unix   to know a command which would help knowing the incoming network connections through(from & to) different ip-address:ports netstat -anp | grep "port" | grep "process" Transmitting data to server through code in linux int no_of_bytes_to_send; char* buffer[100]; no_of_bytes_to_send=sizeof(buffer); while(no_of_bytes_to_send>0) { int byte_send = send(sd,buffer,no_of_bytes_to_send); no_of_bytes_to_send = no_of_bytes_to_send - byte_send; buffer+=byte_send; }