1) Read the article whose link is listed below in my signature block.

2) Post everything the article tells you to post, CREATE TABLE statements for ALL TABLES/VIEWS involved(TESTED to be...

Look up the following in Books Online. you will find an example there.

sys.dm_db_index_physical_stats dynamic management function

Hard to say. I find debugging SSIS packages difficult based solely on a desription of what is going on. Is it possible to save the package to file...

The catch all phrase: It Depends.

If the applications using the databases are 3rd party, you shuld base it on what they currently support. If they are in-house applications, would...

There is also the time differential involved as well. Of course, if the Indian company is running 7 x 24, that won't be an issue.

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...