SQL Server

There are two ways to backup SQL Server databases, one is to use backup database to back up the databases, and the other is to copy the database file MDF and log file LDF directly. The following is a discussion of the latter's backup and recovery.

1: Graphical interface setting foreign keyResolve:table-> Selected Table->design-> Select the field that you want to set the foreign key to, choose Relationships, select Add, select the right ellipsis (see figure I), and then select the relationship

First of all, this SQL Server mechanism is actually very rigorous, his intention is to---if you do not log backup, you do not delete the log, and then there are scripts for you to reclaim the log space, it is very safe and convenient and

Replication: Data transfer to other servers to store, do backup.Mirror: The primary server database is hung and the other one is automatically run as the primary server.LOG: a controllable image.Cluster: The primary server is hung, and the other one

Quickly delete duplicate records in SQL Server 2006-07-17 21:53:15Category: SQL Server 　　 Developer's Nightmare-delete duplicate recordsPresumably, every developer has had a similar experience, when querying or statistics of the

SQL Server attach database failed with error: 5 Access denied resolution King SQL Server additional database denied accessToday, the project is copied to the new hard drive, found in the attached database prompt: Operating system error 5: "5 Access

SQL Server, if the data is mistakenly deleted, according to the official statement, SQL Server is not undelete. To save the deleted data, the most typical way is to restore the data from another DB and then add it back to the formal db by restoring

Issue background:When working with SQL Server 2005 relational databases on a daily basis, it is sometimes unusual for a database (such as SharePoint site configuration database name Sharepoint_config) to stop the database for no reason, such as when

Transferred from: http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/The title of this post was what I can express here for this Quick blog post. I was asked in recent Query tuning consultation project, if I can

Source: Chief brother Welcome to share original to Bole headlinesBlog Preface SQL Server aggregate function in the actual work to meet the needs of a wide range of requirements, and for the optimization of the aggregation function has

Background:My company's official website uses PHP for re-development, abandoned the original. NET development environment, but need to use some of the old official website data, so need to do data migration.The environment is as follows:Old official

The core of SQL Server support for XML lies in the format of XML data, which can store XML data in objects in the database, such as variables, columns, and parameters. When you configure one of these objects with an XML data type, you specify the

This error occurs when the directory selected by the generic backup file is the disk root or the backup selected partition does not grant the SQL Server user read and write permissions.The solution is to grant SQL Server users permission:Select the

text and image functions　　1. Find a specific string patindexSyntax is the same as String patindex.　　2. Get text pointer textptrWhen SQL Server stores text types (ntext, text), and image data types (images), the default is stored separately from data

SQL Server parallel operation optimization prevents parallel operations from being restrained and affects SQL Execution efficiency and SQL Execution Efficiency Why should I also say SQL Server Parallelism: I have written many articles about SQL

SQL (MSSQLSERVER) Service Startup error code 3414 solution, mssqlserver3414 A customer contacted me and said that their front-end system reported an error and sent me an error picture. The first time I saw the error, I knew it wasDatabase

Questions raised by sys. dm_ OS _waiting_tasks of SQL Server Applications (I ), Many users wait through sys when viewing SQL statements. view dm_exec_requests. The waiting type is also obtained through wait_type, sys. dm_ OS _waiting_tasks can also

SQL Server trigger details, SQL Server trigger Trigger is a method provided by SQL server to programmers and data analysts to ensure data integrity. It is a special stored procedure related to table events, its execution is not called by a program,

Processing Methods for statistics of auto-increment key columns and statistical methods This article explains how to handle the statistics of auto-incrementing key columns in the form of text code. We all know that each statistical object in SQL

A few questions about SQL (SQL advanced) and SQL advanced When we get a question, we are not eager to answer the question. It will not be worth the candle, but to analyze the ideas, methods, and objectives, we also need to think about whether there