mdf file in sql server

Label:Open the installation directory of the MSSQL database management system, for example: X:\Program Files\Microsoft SQL Server\MSSQL10. MSSQL Server\mssql\DATA. Where x:\ is the drive letter where you install the MS SQL database management System instance. Delete X:\Program Files\Microsoft

always closed), normal after the big file can be deleted.Of course, the best way is to plan in advance, set up, add a job schedule, so that will automatically back up, shrinkage and the like, control in a certain size range.After learning, the other simple processing methods:1: Empty the LogDUMP TRANSACTION Library name with NO_LOG2: Shrink LogEnterprise Manager--Right click on the database you want to shrink--all tasks--shrink the database--Shrink t

Label:Restore a full backup first, but be sure to select with Nonerecovery in the full backup (option 2nd in Enterprise Manager) The SQL statement is: Restore Database MyData from disk = ' C:\temp\movedb.bak ' WITH NORECOVERY The database then becomes the recovery mode, so you can restore the trn file by adding it in one piece. Statement is: Restore log Mydata from disk = "D:\Program Files\Microsoft

SQL2005 restoring the database failed with the following: "Cannot select File or filegroup Xxx_log workaround for this action when SQL Server 2005 restores the database"when an error occurs , right-click the database---task---restore---file and filegroup---Source device (select backup

Tags: Batch file forfiles RAC file backup auto with win batOne. Create a SQL file and write the following code in it:Use MasterGODECLARE @str varchar (100)Set @str = ' D:\sqlserver14backup\CDB\ ' +replace (replace (replace (CONVERT (Varchar,getdate (), 20), '-', '), ', '), ': ', ' ) + '. Bak 'BACKUP DATABASE [CDB] to [

Label:The company has to standardize the size of the personnel library every month.The following is a SQL Server with the size of the SQL repository:SELECT db_name(database_id) as [Database Name], [Name] as [Logical Name], ((Size* 8)/ 1024x768) as [Size (MB)],--the original unit of size is bit, so multiply 8 to byte and multiply by 1024 to MByte. [Diff

To update a binary file in SQL Server using the OleDbCommand object Author Zhu Yi Using the Oledbconnectionoledbcommand in Ado.net makes it easy to update binaries in SQL Server, the following is a detailed code demonstration Demo Environment: Database machine Name: s_test L

is_user_processWhen 1 Then ' user Session 'When 0 Then ' system session 'END as [SESSION Type],S.row_count as [row Count]From sys.dm_db_session_space_usage su INNER joins sys.dm_exec_sessions s on su.session_id = s.session_idBelow is the situation when SQL Server would use the temp file. Usage of table variables or temporary tables

First of allUse [database name];exec sp_helpfile; Use the sp_helpfile query to know the logical name of the log file, and then you can use DBCC to reduce the log fileBACKUP LOG [database name] WITH TRUNCATE_ONLYDBCC SHRINKFILE (logical name of log file],1) This method is no longer applicable in MS SQL Server 2008 and

Follow the steps to avoid damaging your database if you do not follow the previous steps. Generally do not recommend to do 4th, 62 steps, 4th step unsafe, it is possible to damage the database or loss of data. 6th step if the log reaches the upper limit, subsequent database processing will fail, and the log will not be restored until it is cleaned. 1. Empty log DUMP TRANSACTION Library name with NO_LOG 2. Truncate the transaction log BACKUP LOG database name with NO_LOG 3. Shrink the datab

Tags: SP file data bs Database as SQL file server1, the database is broken down into a logical page, each page 8K, in each file page from 0--x continuous numbering;2, can be [database_id] [file_id] [page_id] in the form of reference page;3, ALTER DATABASE expands the file at

Tags: status cursor Service TXT master * * * EXTC Query codeSET @PATH = ' textcopy/s ' + @LServer + '/u ' + @LUser + '/P ' + @LPass + '/d ' + @LDB + '/T '[email protected]+ '/C ' [email protected]+ '/w '[email protected] '/F ' + @LPath + ' \ ' + @File + '/o ' EXEC Master. xp_cmdshell @Path /** description @LServer: Server name @LUser: User Name @LPass: Password @LDB: Database @table: Table Name @column: Co

Original: SQL Server bulk log file processingOptimized processing for SqlServer2000, SqlServer2005, SqlServer2008, SqlServer2012, and SqlServer2014 library log files, reducing disk space.Processing method:The following columns are SqlServer2012:　　Recovery mode: Complete-Simple, then click OK　　Right-click the database, tasks, shrink-

Tags: blog http using file ar HTML management ampSQL Server backup file management, and offsite backup1.sqlserver executes exec managerdb.dbo automatically. [Del_bak] Backup dbManagerdb.dbo. [Del_bak] Related scripts see the following links:http://dwchaoyue.blog.51cto.com/2826417/14391262.window Automation Task D:\script\Backup.bat compressed files to the backup

); }} Console.WriteLine ("transcoding Complete, total transcoding {0} bar data", Count); Console.WriteLine ("start importing data, please wait a moment"); stringsql ="BULK INSERT Test.dbo.BagDataTable from ' C:\\users\\administrator\\desktop\\writedemo.csv ' with (fieldterminator= ', ', batchsize=100000,firstrow=2)"; Try{dbhelper.executesql (SQL); } Catch(Exception ex) {using(StreamWriter Writerlog =NewStreamWriter (@"C:\Users\Administrato