9 reputation
13
bio website
location
age
visits member for 2 years, 6 months
seen Aug 15 at 20:21

Aug
12
comment Last few rows from a non-indexed table in Oracle
This was very insightful guys. Based on all the answers here, I chose to make a business case to fix the data structure on the Oracle DB and for the meantime, cached a smaller subset of the data I need and broke the query down into multiple pieces. Like Mat and Phil said, there is so shortcut/silver bullet. Thank you all.
Aug
6
comment Last few rows from a non-indexed table in Oracle
Unfortunately, no. No edits to the big table.
Aug
6
comment Last few rows from a non-indexed table in Oracle
My apologies. I know I'm looking for the last few rows in the table because they are the most recent [based on date].
Aug
6
asked Last few rows from a non-indexed table in Oracle
Jan
29
awarded  Notable Question
Jun
19
awarded  Popular Question
May
22
revised Full and differential restore with two backup files - SQL Server 2008
Added info requested by community
May
21
awarded  Editor
May
21
revised Full and differential restore with two backup files - SQL Server 2008
added 255 characters in body
May
21
comment Full and differential restore with two backup files - SQL Server 2008
My full backup has the right name. I have no issues restoring the full database. It's the differential that has the "wrong" name. Eg: full - "DBxxx.BAK" and differential - "DBXXX_Delta.BAK" And the error I'm getting is when I try to restore the database using the differential backup after I run a full restore. Thanks for all the help. I'm sorry if I haven't been very informative so far.
May
21
comment Full and differential restore with two backup files - SQL Server 2008
thanks jgardner. Are you suggesting I use the REPLACE option? Can I use the WITH REPLACE option with the differential backup? Wouldn't that overwrite the database with the changes since the last full backup as opposed to updating them?
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Yes. And no, I am using the WITH NORECOVERY option with the full database backup but WITH RECOVERY for the differential backup.
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Thank you. msdn.microsoft.com/en-us/library/ms188248.aspx#TsqlProcedure mentions backing up 2 types [full and differential] to the same backup device which prompted my question about adding the diff .BAK file to the existing device. I tried using 2 different backup devices but received the error "The backup set holds a backup of a database other than the existing 'DBXXX' database." This could be because the delta backup has a different name though.
May
21
awarded  Student
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Yes, they are in fact from the same database. I'm not sure why they [order processing entity] use different names. If I could ask them to use the same names on both backups, could I add them both to the same backup device?
May
21
asked Full and differential restore with two backup files - SQL Server 2008