mdf file in sql server

Transaction logs are very important but often ignored in the database structure. Since it is not as active as the schema in the database, few people are concerned about transaction logs. Transaction logs are records of database changes. They can record any operations on the database and save the record results in an independent file. Transaction logs are fully recorded for every transaction process. Based on these records, data files can be restored t

2014, destined to deal with the database, and the task is to be related to the database management, a civil aviation system database optimization, a high-availability database, a mobile phone chain enterprise database read and write separation, a quick connection enterprise database migration, suddenly feel foot 2014 how? So, ready to write a few articles on database management, today is the beginning of it.About the management of database files, I often say, often mixed in the lake, which has n

Original: SQL Server file operationIn the master database, SQL Server provides system-extended stored procedures, where some stored procedures are named starting with Xp_ and are used to process the operating system's files.One, determine whether the

I believe that you will often encounter the problem of exporting SQL Server query results to Excel. If the number of export times is small, simply "Save Results; 1.1 prepare the query statement 1.2 select a database and start the Import and Export wizard 1.3 select a data source 1.4 select a target 1.5 1.6 1.7 1.8 Click "Next" until the next step is displayed. 2. But it is quite troublesome to sample

Today the Sql-server database suddenly complains: SQL Server has detected a consistent, logical I/O error checksum (should be: 0x7c781313, but actually: 0X67A313C9). In the file ' C:\Program Files\Microsoft SQL

to execute Business data query//////////* Business table name to back up data/* Declare cur_tables cursor FOR select name from sysobjects where 1=1 and type= ' U ' and nam E like ' wm_order% ' or name like ' wm_picking% ' or name like ' rp_% ' begin try open cur_tables; FETCH NEXT from cur_tables into @table_name; While @ @FETCH_STATUS = 0 Begin set @file_name = '; Set @file_path = '; Set @sql = ' select * from Dhl_posm_ws ... ' + @table_name; Set @

After data migration, using SQL Server 2012 to back up the database, after the completion of the backup is automatically compressed into RAR files, the previous execution of the statement can only do a backup, but not automatically compress and delete the backup, indicating that the problem occurs after performing a backup compression. Copy the statement to Query Analyzer to perform an error, prompting "RAR

Label:Today made a very annoying thing, accidentally put a 40 more g of the database log files deleted, and before the deletion I made a log in, dead or alive can not attach to the server has been prompted multiple logs cannot be automatically created, wasted a night of my time, and then constantly Google, Finally in a foreigner's blog found a few statements, directly, thank him on the way to record. 1 2 3 4 5 6 7 8 9 10 11 USE

When using SQL Server and SSIS to import a CSV file to a database recently (SSIS chooses FlatFileSource as the source of the data stream), you always encounter the LocaleID 4 is isn't installed on this system. this error.Later, long time found that there was a problem with the locale option selection on FlatFileSource, because the CSV

Label: USE [master] GO -- Method 1: I use this method EXECsp_attach_single_file_db @dbname=‘TestDb‘, @physname=N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘ GO -- Method 2: CREATEDATABASETestDbON (FILENAME = N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERV

allows you to specify a query for output. This can be as simple as the query we use or as complicated as you need. You can also create a view and select data from the view. L file name stores the results. It is located after the queryout option. The l-T parameter specifies that the bcp utility uses a trusted connection to connect to SQL Server through integrated

Tags: default trace trace autogrow log fileSQL SERVER default tracking app 4--automatic growth of detection log filesUsers complain that the SQL Server database is running very slowly. This query, which is tracked by default, can identify the long run caused by the log file autogrow activity. Why is it so slow?SELECT t

" began, and then check the "suo", and then find the word "rope", according to its page, Turn to the page where the word is located. Of course this requires that 1. All Chinese characters in the Xinhua dictionary are arranged in phonetic alphabet order. 2. The Xinhua dictionary has a phonetic lookup appendix in front of it. Clustered index is also the reason, 1. There is a "phonetic" list of all the data, that is, the index. 2. All data is arranged sequentially on the hard disk according to this

When we install SQL Server, we see an option below that says "Grant Perform Volume maintenance Task privilege ..." When you specify the account for each SQL Server service to run the startup account. To be precise, this thing is not a thing of SQL

Label:SQL Server transaction log unexpectedly increases or fills up the processing methodTransaction log files transaction log file is a file that is used to record database updates, with an extension of LDF.In SQL Server 7.0 and SQL