check the default trace for the alter statement it is located in youre log directory by default.

roxette (sorry, first thing that came to mind, i know its: how...

peer to peer is designed for low latency envoriments its the adult version of bi directional transactional replication

merge is designed for envoriment where most of the times the "client" databases...

maybe this is shorter and fills in you needs: the maintenance cleanup task

you can even script it http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx

as you posted this in sql 2005 forum i would go for merge. As peer to peer is only sql 2008 enterprise

personal for reporting situations where if teh object of the source database dont often change i like to use transactional replication

this prevents the logrestore/reporting user issue from happening

and afaik log...

you only need to create the linked server once it will stay

about connections it works the same as you query local databases but there will be a dormant spid on...

mlsrinivas (12/22/2010)

---

I tried with DBCC CHECKDB('TransAidDB', REPAIR_REBUILD), but during this trial I am getting an error that database is to be opened in single user access, which I already did...

Several reasons why I dont want a IPAD:

* when you have ipad with the redgate monitoring you re colleagues want 1 to especially you re boss

* Nothing worse then you...

http://sqlserverpedia.com/wiki/Current_Memory_Use_By_SQL_Server

shutts318ci (11/11/2010)

---

Hi, I did read the article yes but unfortunately it doesn't help. When I was in "full" I got the error "full backup does not exist" when I tried...

SQL Server Agent reads the application log and compares events written there to alerts that you have defined.

http://msdn.microsoft.com/en-us/library/ms180982(v=SQL.100).aspx

they dont need to be administrator on the local nodes (you dont even want to) the group is just a regulare domain group which you need to have add permissions...

GilaMonster (10/29/2010)

---

It's...

dont compress will be the prefered option (backup will also be faster)

As you dont run sql 2008 you are not able to compress youre backup during backup (hmm that sounds...