There are many scripts available that will build your restore scripts for you from MSDB. I took one of those, tweaked it for my process and use that process.

For...

Another option is to not allow them to write their own queries. Give them access to only execute stored procedures that you have vetted.

If they need something else, then...

MysteryJimbo (5/18/2012)

---

Its worth reiterating that as Steve says, you will NOT be able to apply transaction log backups. You could potentially attach a database file but this will be...

SAN level snapshots will work - if they are done correctly and managed by the SAN vendors software it is very likely you will have the ability to perform a...

You could also consider database mirroring. Setup the mirroring and when you are ready - failover to the partner, redirect your users and tear down the mirroring.

I would keep it on the tempdb LUN myself, but it would really depend on how heavily tempdb is used on your system and how the LUNs were built, the...

If you have the storage available for the raw data on the server, then you should be able to BCP out the data from the table, truncate the table, add...

I have a 1.8TB database that is currently using 1.6TB of that space. The backups take about 2 hours to complete using Litespeed and I restore that backup to...

As soon as any other application accesses that database and updates data - you will have data integrity issues. In other words, the only way to insure data integrity...

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

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

Kevi322000 (4/16/2012)

---

I have a active/active cluster set up. One node has an alias on a named instance, same with the other node. When I created another instance...

On SQL Server 2008 - I would recommend using CAST({value} AS DATE) instead. This has been optimized so it can still use index seeks where possible and will still...

balasach82 (4/14/2012)

---

Thanks Gail for the immediate response.

Now, I am clear that after dividing the files of tempdb,

1. SQL restart not required

2. Divide the data (mdf) files, like, temp1.mdf, temp2.mdf...

The message clearly states that you should look in the maintenance plan history. Have you done that yet - and if so, what is the error you see from...

You could also purchase SQL Prompt (Redgate) or SQL Assistant (SoftTree) and configure those to your standard. This way, you don't have to worry about hitting the shift key,...