Set up a linked server, then

exec <<linkedserver>>.master.dbo.sp_executesql 'BACKUP DATABASE <<DBName> to disk='\\<<Server>>\e$\<<DBName>.bak''

Of course, inserting the proper servername and drive/directories.

Clustering provides quick failover, usually under one minute. With no changes for DNS (you connect to...

RonKin (4/9/2010)

---

I do not have a SQL Server Test Cluster. I have no one where I work to assist me.

I am currently running SQL Server 2005 Enterprise. I...

No, there are n number of transactions that occur in your...

What version of SQL will you be running?

It's always best to do a clean install of the OS rather than add/remove SQL

Look at the ACL's on the file

The only reasonably accurate way to estimate those numbers is in your test environment. There are many variables in getting a calculation. Are you storing bits, reals, int,...

Mike Hinds (4/8/2010)

---

I usually use...

I've taken a six month contract that I finally left for a new job after 2 years. Remember there are certain accounting rules that make it easier to bring...

lmu92 (4/7/2010)

---

Steve, would you consider a worktable as being the third type of a temp table?...

RamSteve (4/7/2010)

---

I can see sudden jumps some times in the transactions per sec exceding to 3000 and some times 800 and what could be the reason for this sudden...

Stop the service, when you need it start it up.

Take the reporting DB's off-line, when you need them bring them back.

Redirect in IIS to the current server (put up a...

pankaj.baluni (4/7/2010)

---

CirquedeSQLeil (4/6/2010)

---

pankaj.baluni (4/6/2010)

---

AT the time of DR, Storage team will bring up the LUNs for me at the DR Site and I'll turn the SQL servers on. Now as...

Apparently it's too difficult query google for the answers

Are you looking for the FQDN Server Name (like ATLSQLPROD01.MyOrginization.Net)?