Using the native SQL backup you can backup and restore individual files/filegroups.  Again, please read BOL.  It does have the information you need to get started.  Our databases are not...

The native SQL Backup can be run while the database is in use.  Most third party backup software can also backup SQL databases while they are online as well.  Take...

You should also be aware that Full and Differential backups do not truncate the log file if your database is in bulk-logged or full recovery mode.  If this is the...

The short answer is yes.  You can not do a transaction log backup of a database set to the simple recovery model.  In this mode, the transaction log is automatically...

Would ylu please post the entire error message you are getting.  I can't find anything regarding SQL Server error 17.

Not true.  Go to this site: http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Download the SQLServer2005Licensingv1.1.doc

This is what it says regarding Per Processor:

Microsoft offers a processor-based licensing model to...

I was looking at the Microsoft SQL Server 2005 Web Site and found this:

Processor Licensing Model. Under this model, a license is required for each physical or virtual processor...

From the Microsoft Web Site:

Under this structure, a customer acquires a separate Processor license for each processor that is located in the server running the SQL Server software. If you...

As I understand it.  It you are using Integrated Security, yes you need User CAL's for everyone who could potentially access your system.  If you are using SQL Authentication, Windows...

It also depends on how the users are authenticating through the Web application.  If it using NT Authentication, then yes, each user needs a Windows Server 2003 User CAL.  This...

To use Windows Authentication to SQLServer1 in Domain2 you need to add your Domain1 user account (Domain1\user) as a login to SQLServer1.

hth,

Try this and see if it works:

select

    a.ItemNumber

    a.OrderNumber,

    a.Quantity,

    a.DueDate

from

    dbo.Orders a

where

    a.OrderNumber in (  select top 3

                            b.OrderNumber

                        from

                            dbo.Orders b

                        where

                            b.ItemNumber = a.ItemNumber

                        order by

                            b.DueDate

                       ...

Remember what a differential backup is: all database changes since the LAST full backup.  In this case the differential backup taken at 9/25/2006 @ 13:00 has all changes since the...

I don't have the answer, but what you were told is not completely accurate.  The backup/restore processes use tables in msdb to record information and in SQL 7.0/2000 when DTS...

pgh1 and pgh2 are aliases for the tables in the queries.

One thing that would help would be to have the table structures and some sample data to work with and...