Viewing 15 posts - 23,716 through 23,730 (of 26,486 total)
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.
November 17, 2008 at 11:55 am
And my suggestion still stands as well, change master.dbo.sysdatabases to sys.databases.
November 17, 2008 at 11:47 am
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
...
November 17, 2008 at 11:30 am
Can you do the restores manually using the original backup files to see if they work?
November 17, 2008 at 11:23 am
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...
November 17, 2008 at 11:17 am
Try this:
;with Ages (
acres,
AgeClass
) as (
select
acres,
case
...
November 17, 2008 at 10:13 am
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...
November 17, 2008 at 10:09 am
I notice that the restore code you posted doesn't have date stamps in the files name, but your backup code does.
November 17, 2008 at 10:05 am
Greg Charles (11/17/2008)
Try removing "WITH REPLACE" from the differential restore statement. I think you only need that on the full restore.
Doesn't matter. If you use SSMS to script...
November 17, 2008 at 9:59 am
jsheldon (11/17/2008)
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...
November 17, 2008 at 9:55 am
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...
November 17, 2008 at 9:51 am
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.
November 17, 2008 at 9:38 am
Can you post the code for your backups?
November 17, 2008 at 9:30 am
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. ...
November 17, 2008 at 9:23 am
aveerabadran (11/17/2008)
November 17, 2008 at 9:11 am
Viewing 15 posts - 23,716 through 23,730 (of 26,486 total)