mdf file in sql server

Tags: DBCC article BSP color size ASE file detail supportSQL Server log file too large log file cleanup method, the network provides a lot of separate database--〉 delete log files-〉 Additional database method, this method is too risky, the process is relatively long, and sometimes there will be the phenomenon of separa

Original: http://www.nigelrivett.net/SQLTsql/WriteTextFile.htmlThe is several methods of creating text files from SQL Server. osql Bcp Redirection commands Sp_makewebtask Com Object Calls Remember that in all cases the path of the output file is relative to the server-not to the client on

Tags: des style c Class Blog codeOriginal: What is the size of the SQL Server log file's write operation to the disk?The SQL Server database has three file types, data files, secondary data files, and log files, where the log files contain all the log information used to rec

Tags: base upd src inf paid erro values CLU pointOriginal: SQL Server log file structure and error operation data retrievalI. Overview In SQL Server, there are data files. mdf and log files. ldf, the log

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.Use [master]go--Method 1:i with this methodexec sp_attach_

There is already a DOE database on the SQLServer server and there is a large amount of data in it. Now we are preparing to use another backup file A1.BAK (not the backup file of the DOE database) import other data (that is, add some data tables to the DOE after the import, the table has already recorded data), and keep the data of the original DOE unchanged. 1. F

not available. Remind: Open execution order is ' show advanced options ' before executing ' xp_cmdshell '. , if you want to turn off this advanced option, execute ' xp_cmdshell ' and then ' show advance options '. The number 1 is on and 0 is off. If the Cmdshell is not working yet, run it again:DBCC ADDEXTENDEDPROC ("xp_cmdshell", "Xplog70.dll");--OrSp_addextendedproc xp_cmdshell, @dllname = ' Xplog70.dll 'To restore Cmdshell. 2. Execute Master.dbo.xp_cmdshell ' osql-u sa-p 123456-i d:\test.s

a master data file, and the file name extension of the master data file is. mdf.• Secondary (secondary) data files: All other data files except the master data file are secondary data files, some databases may not contain any secondary data files, and some databases contain

The SQL Server database has three file types, data files, secondary data files, and log files, where the log files contain all the log information used to recover the database, SQL Server always writes the log file LDF first, and

1. first, import the Mysql database file to NavicatPremium. 2. click the ExportWizard button to display the interface. Select MSAccessdatabase (*, mdb) 3. next, select Path 4. next, select Append.5. Click Start. The following page appears. 6. there will be one on the desktop. open an mdb file such as SQLServer 1. first, import the Mysql database file to Navicat

. Here, a minimum number of MB allowed to be shrunk is displayed. Enter this number directly and click OK.You can also use SQL statements to complete-- Shrink DatabaseDBCC shrinkdatabase (database name)-- Contract the specified data file. 1 is the file number. You can use this statement to query: Select * From sysfilesDBCC shrinkfile (1)4. To minimize log files (

Welcome to the Windows community forum and interact with 3 million technical staff. 1. Run USEmaster directly without creating a database. GOCREATEDATABASEtestON (FILENAMED: ProgramFilesMicrosoftSQLServerMSSQL10.MSSQLSERVERMSSQLDATAtest. mdf), (FILENAMED: Pr Welcome to the Windows community forum and interact with 3 million technical staff> GO to 1: run the USE master directly without creating a DATABASE; go create database test ON (FILENAME = 'd: \

to complete -- Shrink Database Dbcc shrinkdatabase (customer profile) -- Contract the specified data file. 1 indicates the file number. You can use this statement to query: Select * from sysfiles Dbcc shrinkfile (1) 4. To minimize log files (for SQL 7.0, this step can only be performed in the query analyzer) A. Separate the database: Enterprise Manager --

the database MDF file. You will be prompted to find the. ldf file. You can delete it directly, such asafter deleting, click OK and the database is attached. The newly generated LDF file is only 504 KB1. After detaching the database into the directory after deleting the. ldf file