You can backup over the network using a UNC name. You don't need to set up a device, you just need to do:-

BACKUP DATBABASE dbname TO DISK='\\servername\sharename\path\file'

SQL Server must be...

You have to give the relevant permissions on database A, and let the permissions changes work their way to database B via log shipping.

Note. If database A and Database B...

SQL Server will only create these pseudo indexes if you have the 'Auto Create Statistics' option set on.

You probably have the option set on for the database with 250 indexes,...

You probably have one or more read only databases, and therefore cannot update the access permissions for those databases.

Enterprise manager is just telling you that those databases aren't being included...

You can't back up a database that is in STANDBY or NORECOVER mode. Log shipping will leave the database at the standby server in one of these 2 modes.

Look in the C:\Winnt (or wherever you installed Windows) directory on each node in the cluster.

Look for the latest sqlstp*.log file. This gives detailed information about the setup processs.

There will...

Just do:-

select @na = [na] FROM [xsisi]

Try running the following command immediately before the restore:-

alter database dbname set single_user with rollback immediate

The error message generated when you tried to connect as 'sa' looks like the server is set up for Windows authentication only, not SQL Server and Windows authentication.

The second attempt...

You can always make the sort column the first column in the select statement, and then use a case statement to determine the actual column e.g.

declare @order int

set @order =...

Try running sp_spaceused @updateusage=true

You need to use the value of the variable @file to create the dynamic statement i.e.

SET @sql = "BULK INSERT temp FROM '" + @file1 + "' WITH (FIELDTERMINATOR...

INSERT TABLE1

SELECT 1,614,ID

FROM TABLE2

WHERE PROJECTID IN (18, 26, 20, 22, 35, 38, 148, 149, 155, 278)

Yes, the Log shipping backups are sufficient for backing up, they are legitimate transaction log backups.

If you introduce separate log backups you run the risk of breaking the log shipping...

It doesn't work because SQL thinks the contents of your variable is a single item in the IN clause. i.e. it is searching for ''orders'',''syscomments'',''sysobjects''

If you create the whole select...