From BOL:

--To Restore an Entire Database from a Full database backup (a Complete Restore):

RESTORE DATABASE { database_name | @database_name_var }

[ FROM <backup_device> [ ,...n ] ]

[ WITH...

omer_abdalla (1/11/2011)

---

Can a similar task be setup to cleanup old audit trace files (extension trc)? because I tried with no luck (I chose type "backup files" and also type text...

Actually, the first backup you performed before shrinking the log file wasn't technically necessary. As soon as you changed the recovery model from full to simple - the virtual...

The database engine and analysis services engines are services - not applications. You won't see them in Programs, but you will see them in the services applet (services.msc).

It sounds...

willtwc (1/3/2011)

---

I used this in a job step prior to the lightspeed restore and it works fine restoring from prod to dev.

DECLARE @DatabaseName nvarchar(50)

DECLARE @SPId int

DECLARE @userid varchar(100)

declare @command varchar(200)

SET...

So, you are restoring the backup to another system - not the same system.

It looked like you were backing up the database, and restoring it to the same system. ...

I use Litespeed...

Now I have to ask - why would you do this?

It really does not make any sense to backup the current database, then immediately restore over the existing database that...

Actually - it is called...

Not sure about Azure and what is available or not - but lookup WAITFOR in BOL. That will allow your process to sleep for a time and start up...

Also a bit late, but if SSIS is not installed on that server - then I would think the package is also not installed on that server. If it...

First, what do you believe the certs will give you - that you don't already have through time and experience?

Is there a goal here besides just getting a certificate?

I wouldn't...

And,...

Yes - it is possible to run multiple instances in a cluster, and no reason why you cannot run both 2008 and 2005 on the same cluster.

Remember, in a cluster...

A couple of things:

1) Are you sure you are running SQL Server 2008 Enterprise Edition and not Standard Edition? Use one of the following to verify:

Select @@version;

Select serverproperty('Edition');

Note: Standard...