SQLCMD did replace OSQL so you should use SQLCMD if you can. However OSQL should still be there if you have installed SQL2008

You would find it in c:\program files\microsoft ...

EdVassie (1/7/2014)

---

Can you SELECT * FROM sysdatabases and see if you have a database with an ID of 2. If you have, this DB is being used as the...

Some white papers comparing the various HA techniques

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

http://technet.microsoft.com/library/Cc917680

Do you have standard or enterprise edition? To make the secondary databases readable with mirroring you need enterprise edition so you can snapshot...

be aware your resource database will stay on the C drive and there is nothing you can do about that short of a reinstall.

I think to help you people will need at least the update statement as well, but preferably either the XML from the deadlock graph in profiler or the output from...

First of all congratulations to everyone, when I see this type of article I normally cringe, expecting a bun fight, but this one has not descended into name calling and...

not via SQL native I am afraid.

you could do more stripes and send more to one drive than another?

if its not, start worrying.

Grant Fritchey (1/3/2014)

---

If you feel like your log files are getting too large, you probably should take the backups more frequently. But, that will mean you have to manage more...

Oh, and growth factor for the log, get the log set to the size it needs to be to accommodate all activity first so hopefully it does not actually need...

tt-615680 (1/3/2014)

---

Dear All,

There have been issues in the past where the transactional log file has grown too big that it made the drive to limit its size. I would...

Andrew Andrews (12/31/2013)

---

In a nutshell, if you're constantly defragmenting indexes, you are writing more data to transaction logs, making backups take far longer, and overworking your SAN needlessly. Also, mirroring,...

I would read that If as an 'as well'. This is because the clustered index is still being dropped, but the data is moved at the same time, but is...

sounds like you want the secondary database to be updateable, is that correct? If so replication in a form that allows updateable subscribers is your only option, .

If this...

Thomas Abraham (1/2/2014)

---

Got it wrong as I was using http://technet.microsoft.com/en-us/library/ms176118.aspx as a reference and it says, in part:

If a clustered index is dropped by using MOVE TO, any nonclustered indexes...