Andrew Jackson

There are several benefits of a database snapshot in SQL Server. Here I have discussed some of them:
1. The database snapshots can be used in reporting services.
2. Works as a safeguards against administrative error.
3. Also can be used in managing the test database.
4. Can be used as mirror database that you can use for maintaining for availability purposes.

Some limitations are like:
1. Snapshots are read-only.
2. specifications of the database snapshot files are not changeable.
3. You cannot attach or detach database snapshots.
To know more please go this one it may be helpful to you https://msdn.microsoft.com/en-us/library/ms175158.aspx

This error generally happens when users configured an asp.net application to IIS, and IIS tries to gain access (login) with improper permission.

To fix this error

• Open SQL Server Management Studio >> Security >> Logins (right click on the user) >> Properties
  



• On Login Properties window, click on User Mapping from the left pane.
• Under Users Mapped to this login: select the database and from the lower screen (Database role membership for: Database) check db_owner role and click ok

First of all make sure that you do not detach suspected database
Then execute the following query:

EXEC sp_resetstatus 'DatabaseName';
ALTER DATABASE DatabaseName SET EMERGENCY
DBCC checkdb('DatabaseName')
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DatabaseName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DatabaseName SET MULTI_USER

You can also use FILEPROPERTY to check for free space in a SQL Server database

USE AdventureWorks 
GO 

SELECT DB_NAME() AS DbName, 
name AS FileName, 
size/128.0 AS CurrentSizeMB,  
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB 
FROM sys.database_files;

This will show how much space is used by SQL Server database and then you can calculate free space

To change the name of the physical file you have to take the SQL Server database Offline

• Open SQL Server Management Studio
• Right-click on Database which you want to rename
• Click on Tasks
• Then select Take Offline

Change the name of the physical files at the OS level and then Bring the database Online.

The select @@TRANCOUNT will help you to check active transactions in SQL Server

Thanks Lincoln,
I had gone through the demo version and yes there is a separate option to “Remove Duplicate Folders”,
Now I am eagerly looking forward to using this utility.

Hi buddy,
I have been working for my enterprise since last 2-3 years and we are using Lotus Notes database to store all the account related information.
As the mail client I am using creates the archive account to months, hence many NSF files had been created of my account having different folders. This situation leads to cumbersome task to access the data in those files by opening them one by one which is very time consuming.
Secondly, the search options can’t be used efficiently if there are many files of the same user account which is different for inbox, calendars, events etc.
So, is there a solution to combine all my NSF Archive Database to a single file. I am in dire need to have a solution as it will ease my work.

Try this:

SELECT * 
INTO DestinationDB..MyDestinationTable 
FROM SourceDB..MySourceTable 

It will not copy constraints, defaults or indexes.