You can backup to a drive on any server using a UNC path.  Create a backup device of DISK='\\servername\share'

You can either do this in enterprise manager by creating the backup on server A and restoring it on server B by choosing the restore from device option in the...

one query you can use to determine the service pack level of SQL Server (with other info) is:

select serverproperty('productlevel') as 'Service Pack', serverproperty('edition') as edition, serverproperty('productversion') as 'build number'

@@servername will return null if you run sp_addserver 'servername' without the additional 'local' parameter.  Conveniently enought Books online tells you to do this wrong.  Always make sure that you add...

In a data warehouse you would typically not care about point in time recovery functionality so I would guess that a simple recovery model is what you are looking for....

My post was not a knock on Red Gate's product at all.  I was commenting on the statement that LiteSpeed is not a mature enough product to put into a production...

This was a query only suited for the example given at the beginning of the thread.  If there is one stripe of the backup file called 'f:\mssql\backup\DBATEST.bak' this query will...

Whenever dealing with a 3rd party backup product it is always helpful to determine if the error is related to SQL Server or the 3rd party product itself.  In order...

Microsoft is not only a customer they have Standardized on LiteSpeed.  Other companies such as Countrywide have also standardized on LiteSpeed and are using it in production on 100+ servers. ...

The backup you are trying to restore from is part of a striped backup set. In order to restore this file you will need to provide both parts of...

Imceda's auditing solutions are now both available for general download.

SQL Watch will alert via SMTP mail whenever a DDL change occurs on a database. It will alert and also...

You can download Imceda's auditing solutions now. Go to http://www.imceda.com and take a look at SQL Watch and SQL Forensics.

Theres really no way to find out what happened unless you have some solution put in place to monitor this. Using a log reading tool you can read the...

Tracing is only really an option if you can deal with a fairly substantial overhead.

You should take a look at Imceda's new product called SQL Watch. This product is...

Are you sure that the backup is not writing? In windows 2000 if you are viewing the backup file in windows explorer you will not see the filesize grow...