Thanks Philip, I take it you can't combine drop/create in the same script? Also is there a way to make the process generate one file per table?

Cheers

Pete

Hi John,

My test did give a timeout error, what I was trying to say by showing this was that another process may have been table locking and that was causing his...

Ah ok, sorry I'm having  a blonde day 🙂

I'm still interested though, what would be the advantage of having multiple drive/volumes? There would be no performance difference between having one...

I am intrigued now.... Why will multiple files be better than a single file? If the SAN controller can put the different bits of data on multiple drives where is...

HI,

A very simple test... I created a temporary table started  a transaction inserted some data and on another session tried the DBCC INDEXDEFRAG and I got a lock .......

Does the DTS package runs succesfully when you run it within Enteprise Manager?

Hi,

Not sure this will help... Are you calling the command from SQL Query Analyzer? If so there is an option to set the Query timeout, is this set to 0...

Hi,

SQL Server requires at least one data file and one log file (.MDF and .LDF)

There is no advantage creating multiple log files as the SAN is managing which physical disk...

Because I don't know which tables have been allocated to which file because the new files have been added to the primary filegroup. Therefore I don't know how to correctly...

Hi Sanjay,

To avoid having to make the change I have created 2 stored procedures to perform the backups to a NAS server...

Backup ....

/*

Description

------------------

This stored procedure will backup the requested database.

Amendment...

Hi,

Probably silly question, but are you running MS DTC on both servers? Is the other database Sqlserver?

Pete

Thanks... That seemed to have worked.. I was right the full backup was not associated with the incremental one.

Also I found that you can find the same information from the...

Hi,

Not sure if this helps, but I think the table msdb..backupset holds some of this information

Might be wrong though...

Pete

Hi Kishore,

Thanks for that... I know what backup type they are by the naming convention  (WK0 = full) WKx (x = 1 --> 7 ) differential.

Can I use the...

Hi Kishore,

I dont think this is our backup file because someone else has done some restores previously which has made the BACKUP_2005_WK10_DAY0.BAK invalid I think that is why the process...