Check the mount point whether ADS (Alternate Data Stream) is enabled or not?

DBCC CheckDb uses internal snapshot.

NTFS file system alternate streams that are used for the internal snapshot

Whether the kb-936488 worked for you?

Option : 1

Considering this query alone,

I recommend creating a clustered index on f3, f4 and...

Hi Deni

You haven't understood my question.

1. Backup & replication

I haven't told anything like backup and replication happenning at the same time.

Backup of database is happening at different time than the...

Hi

1. When you recover database from one backup file, then this option is not required.

Restore database DBNAME from file

2. When you recover database from more than one backup file (1F...

Hi

1. It is better to place the backup files in Enterprise Storage, because you will have access from both the servers.

2. If you plan to keep backup files on hard...

Hi

This is the sql command for attach the database..

EXEC sp_attach_db @dbname = N'pubs',    @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',    @filename2 = N'c:\Program Files\Microsoft SQL...

Hi Kishore

Newbie query is not working for the below values.. updated one for you

create table sa

(

id int,

value int)

insert sa values(1,100)

insert sa values(1,200)

insert sa values(2,50)

insert sa values(2,100)

insert sa values(3,300)

insert...