Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

How To Backup Your SQL Server Database

How To Backup Your SQL Server Database To keep your database safe, we have to take backup of our databases.Their are several type of backup (Full,differential,Transaction log). Full Backup:- A Full database backup creates a stand-alone image of the entire database. A  full database backup is self-dependent and may be restored to either the  same or a

How To Recover Lost SA Password In SQL Server

How To Recover Lost SA Password In SQL Server If you’ve forgotten the sa password for your SQL server, Sure you are in a panic.But Fear not,  you can reset the password and again you have access to sa account by using the New query window in the Management Studio. Open Sql-Server management studio with window authentication. Open New query

How To Know SQL Server Service Pack In Your Machine

How To Know SQL Server Service Pack In Your Machine Hi Guys in this tutorial i will explain you How To Know SQL Server Service Pack In Your Machine.If you’re running SQL Server, it’s wise to keep latest service pack installed for optimum performance. If you’re not sure about service pack (or if you’re still running

How To create a Publication In Replication

How To create a Publication In Replication When creating a publication, you choose the tables and other database objects that you want to publish. You can publish the following database objects using replication.When publishing a table for replication, you can specify which schema objects should be copied to the Subscriber, such as declared referential integrity

What Is Replication And Its Types

What Is Replication And Its Types Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks. Why