looks like you havent restored the latest log backup without recovery on your mirror database

firewall turned on or something like that? is encryption enabled on the connection on any of the databases.. is the mirror db in recovery mode?

What is the sys.tcp_endpoints saying regarding to the ports are they really there and the ones you use. Use netstat to see if the server is really listening on that...

you dont need to have the files in the same place

production is ..production you are not allowed to use the dev edition for it but however you can use any edition for a witness server even the free express edition...

simplest way i can think of is to create a script task and use the system.io.file.existst() method

Make sure the database files are placed in a folder the sqlserver has permission to. Also try using the sp_attach_db if you tried it with the graphical interface and if...

kevinsql7 (1/29/2009)

---

We have SQL Server 2000 and 2005. I would like to know if there is an option I can turn on to monitor logins to our Server/DBs. Also, is...

you can look up dbcc memorystatus or the sys.dm_os_memory_clerks for the buffer pool to see for what the memory is used for

The index rebuild works with the transaction log file so it will be mirrored over which can take quiet some time on a large Index rebuild.

did you touch any of the mdf or log files while db was offline?

as of intel specs it is http://processorfinder.intel.com/Details.aspx?sSpec=SLBBC

if i understand your situation right you can accomplish this by using output http://msdn.microsoft.com/en-us/library/ms177564.aspx

hi

it's sp_cycle_agent_errorlog for the agent logs to change or see folder you can right click on the errorprotocolls and say configure to set path and log level for when it...

did not work for me last time