Can you copy and paste the error from the event viewer to here?

Hello Friends

Can anyone pls suggest me to rectify the issue? I don't want to go for reinitialisation.

Please suggest me something else.

I think I missed you mention that I checked in ErrorLog also (all the error logs generated on the day), but could not find the details. Bad luck !!

No friends. I was consistently running the "select * from sysprocesses" to find the active connections. But there was no blocking \ running jobs during that time other than the...

The weekly update stats job was running.

Thanks Kalyani for your assistance.

I executed the query and found my desired results. [:)]

[font="Arial"]9.0.3033 =>

Here, 9=> SQL Server Version (SQL Server 2005)

0 => Minor Version

3033 =>Hotfix

Now,...

But are you sure, we can't add\delete a new table\sp\view(object) after the replication is setup?

Hello There,

Perform the below steps:

(1) Take a backup of the database which you want to clone.

(2) Run the verifyonly and filelistonly queries to check the consistency of the backups.

xp_restore_filelistonly @filename...

Do we have any T-sql code to know when the indexes of the tables were rebuilt last time?

Thanks Pradeep.

Thanks for the response.

As you have quoted from "Books Online"::

"If the database is in the OFFLINE or EMERGENCY state, BACKUP is not allowed even with NO_TRUNCATE.

"

(1) For the above case, what is the...

Hello Experts

I need a quick response from you guys.

Suppose check the below scenario to understand my requirement:

In my project the Full database backup is being performed everyday night at 10...

Can anyone please respond to my queries?