I just noticed that CHECK constraint behaves like after TRIGGER. That is, the row is inserted then checked whehter it satisfies the...

In norecovery mode its not possible as db will be in recovery mode and you cannot access...

Exactly. You cannot copy these files. Even though if you copy to any other server with any third party utilities also it cannot be attached to any other server.

Database...

I am asked not to create any backup as this would cause server slow. I want to create one snapshot and then take this snap shot file and attach to...

Do you mean the database on secondary server. In which mode...

Hi Sanjay,

Microsoft recommends using create database dbname for attach instead of sp_attach_db.

From bol:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in...

Hi,

As Slick suggested did you checkout using profiler. It will help you to understand whats happening in the backend. Everthing seems to be fine as it is...

Chandu (8/4/2009)

---

What is a tail log ? I believe all the logs (.trn files) are being copied over to secondary server instantly. Sorry if it is silly question, but i...

Hi,

Can you post the create scripts for tables,indexes and some sample data. and also can you post the plan in .sqlplan format. so that we can get...

Hi,

You can check the restorehistory table in msdb database.

Refer http://msdn.microsoft.com/en-us/library/ms187408(SQL.90).aspx

Hi,

You can use the sql server management studio. (Start->Run->sqlwb.exe). You get a connect dialog box asking the servername and your credentials. After supplying the necessary information and...

Hi,

You can execute the following script. I am assuming only one mdf and ldf files (no ndf's)

CREATE DATABASE MYDB

ON

(FILENAME='D:\DATA\MYDB_DATA.MDF'),

(FILENAME='D:\LOGS\MYDB_LOG.LDF')

FOR ATTACH;

For table to be replicated in transactional replication it is must that it should have a primary key. Otherwise it cannot be part of transactional replication.

instead of clearing the log its better if you can increase the size of the log file

start->run

and type eventvwr and click on ok. Eventviewer window will open.

In the Eventviewer window...

In simple

Snapshot replication

snapshot replication generates an initial snapshot of the schema and data from the publisher and applies them to the subscriber. Any subsequent changes like insertion of rows,deletion and...