And my suggestion still stands as well, change master.dbo.sysdatabases to sys.databases.

Or is this what you are trying to write?

select

A.Account_number as 'PRF_CAN_ORDER_LEVEL'

from

dbo.AVW_11i_WA_BILLTO_Customers A

UNION

select

A.Account_number as 'PRF_CAN_OVERRIDE'

from

...

Can you do the restores manually using the original backup files to see if they work?

What you have posted is a mix of both possible solutions.

I think most of us are in agreement that the following may be the best solution, but that we'd still...

Try this:

;with Ages (

acres,

AgeClass

) as (

select

acres,

case

...

Nope. That's why I said test it to be sure. The biggest thing is no surprises.

Last time I looked at PuTTY was as a terminal emulator to connect...

I notice that the restore code you posted doesn't have date stamps in the files name, but your backup code does.

Doesn't matter. If you use SSMS to script...

jsheldon (11/17/2008)

---

ALTER DATABASE DBSallc SET single_user WITH ROLLBACK IMMEDIATE

RESTORE DATABASE DBSallc from disk =

'E:\SQL Backup\Data\DBSallc.bak' WITH REPLACE,

MOVE 'DBSallc_data' TO 'D:\Data\DBSallc.mdf',

MOVE 'DBSallc_log' TO 'E:\DataLog\DBSallc.ldf',

NORECOVERY

RESTORE DATABASE DBSallc from disk =

'E:\SQL Backup\Diff\DBSallc.bak' WITH...

I'd test it running from a job to be sure. The software we are using for SFTP worked fine in development and died when it was ran as a...

1) Indexing, should you find it necessary to index one of the extended fields.

2) Not using the appropriate data type for each column in the table.

Can you post the code for your backups?

First, on the licensing - you can install the Development Edition of MSSQL on a server as long as everyone connecting to it has a developer or MSDN license. ...

aveerabadran (11/17/2008)

---

if i use Send mail task , i need to manually put the smtp server,from & to address , mail subject,etc ..... These info are taken from table and...

As this is posted in a SQL Server 2005 forum, I am going to make a partial assumption, the primary server is running SQL Server 2005. What about the...