In that case, set the database to restricted users before starting the backup. That means that only members of db_owner, db_creator and sysadmin may access the DB.

If that's not...

Snapshots?

It was existing transactional replication that I set up a couple months back to test some stuff and never dropped.

I don't know why that's not working. I did exactly that (except I...

Why do you need to prevent users accessing the DB to do a backup?

What do you want to see in the following cases?

StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 18:00:00

StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 07:00:00

Nothing unusual there. SQL will take as much memory as it's allowed...

What info are you looking for?

Try this:

select * from sys.symmetric_keys

It's not a SQL menu. Window's administrative tools....

asrisl (12/10/2008)

---

Thank you. I found a switch like what you described under "Surface Area Configuration." I trust that is the one to which you were referring. It is set to...

Needs more quotes

CAST(S.xusertype AS INT) = CAST(C.[User_Type_Id] AS INT)

WHERE T.[Name] = ''' + @TableName + ''' AND

T.Schema_Id = 1' --@@@@ (1 = dbo.)

Square brackets denote identifiers, ie table or...

It won't be listed...

sunandas (12/10/2008)

---

I need to do reindexing as the tables are very big and if I wont do reindexing then locking in objects and for which the agent's system are hanged...

Thread continues: http://www.sqlservercentral.com/Forums/Topic616816-1291-1.aspx

Why did you delete the post with the table and index definitions? Please post them again. I can't suggest indexes without having the table definition at the very least.

Means that the corruption was present in that backup. Do you run checkDB regularly?

If this is 2005, check the error log for the startup messages. As SQL brings the DBs...