Stephen West

It depends on two factors: mirroring mode and if the data is getting explicitly commit or implicitly…. The application will read only the committed data.

First of all you should ensure that you have sufficient space on your disk drive to hold the database snapshot. You can create a database snapshot only the help of TSQL command. The SQL Server Management Studio doesn’t provide the facility to create the database snapshot.
Here I have posted a sample query to create the database snapshot.

CREATE DATABASE database_snapshot_name 
    ON
    (
        NAME = logical_file_name,
        FILENAME = 'os_file_name' 
    ) [ ,...n ]
    AS SNAPSHOT OF source_database_name
[;]

Defining a troubleshooting methodology is hard, because the actual methodology that I apply depends entirely on the specific problem that I am trying to troubleshoot for a specific environment.
Fairly early on in any analysis, I’ll take a look at the wait statistics, in the
sys.dm_os_wait_stats Dynamic Management View (DMV), to identify any major resource waits in
the system, at the operating system level.

There are several methods to export a CSV file from SQL Server database.
1. Using SQL Server Management Studio
>>Firstly using SELECT statement filter the data that you want to export.
>>Now, Click on the top-left corner to select all rows
>>After this, Right-Click to copy all the selected
>>The paste the copied content on Microsoft Excel
>>Save as CSV
2. Using SQLCMD (Command Prompt).
3. Using BCP you can export the CSV files.

You can rename sql server database using transact-sql and sql server management studio, however to rename the physical files you need to detach the database. This post shows you step by step method to rename sql server database and physical files:
http://www.sqlserverlogexplorer.com/how-to-rename-a-database/

Hi,
Yes, your point is right regarding the handling of multiples NSF Archive Database files. I have searched through Google for any manual tricks or tips to integrate these files to a single file.
But, sadly I haven’t found any satisfying solution for this problem.
Anybody is welcomed for any tricks or tips to solve this issue.

Try this

SELECT o.name AS TableOrIndex
 FROM sysfiles f
JOIN dbo.sysfilegroups s
 ON f.groupid = s.groupid
JOIN dbo.sysindexes i
 ON i.groupid = s.groupid
JOIN dbo.sysobjects o
 ON i.id = object_id(o.name)
 AND i.indid in (0, 1)
WHERE f.name = 'My_Logical_File_Name'
UNION
SELECT i.name
 FROM sysindexes i join sysfilegroups f ON i.groupid = f.groupid
 JOIN sysfiles l ON f.groupid = l.groupid
WHERE l.name = 'My_Logical_File_Name'

1. SELECT the DISTINCT records into a New Table
2. TRUNCATE the Old Table
3. MERGE the New Table back into the Old Table