Click here to Skip to main content
       

Database

 
GeneralHigh CPU PinmemberDavid Mujica9-Oct-12 9:13 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 21:30 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 23:15 
QuestionMySQL Server timestamp changed! Pinmemberjrahma2-Oct-12 21:53 
AnswerRe: MySQL Server timestamp changed! PinmemberShameel3-Oct-12 4:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit PinmemberSatyam Tripathi2-Oct-12 21:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit PinmvpRichard MacCutchan2-Oct-12 22:00 
QuestionBackup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 10:35 
We have a web application using SQL Server 2008 R2 that contains data for tracking time that another company has expressed interest in using, we initially set up the database such that all end-user tables have a foreign key to what company that row belongs to. Is there a good way to backup/restore the data for a specific company across the tables, such that if the new company says tomorrow that they want their data restored to yesterday; it can be restored without impacting all the other companies data as well? I'm trying to avoid writing some form of stored procedure that selects and then have to do an insert/update/delete to put the data back. Thanks for any insight.
Dennis Daugherty

AnswerRe: Backup/Recover of row data in a multi-Company database PinmvpMika Wendelius2-Oct-12 11:17 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 11:22 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmvpMika Wendelius2-Oct-12 18:22 
AnswerRe: Backup/Recover of row data in a multi-Company database PinmemberMycroft Holmes3-Oct-12 7:39 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberDeDawg3-Oct-12 7:43 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberMycroft Holmes3-Oct-12 8:02 
Questioncannot find column [modified] Pinmembersindhuan1-Oct-12 0:19 
AnswerRe: cannot find column PinmemberEddy Vluggen1-Oct-12 1:00 
QuestionHow to Recover Deleted rows from sql 2000 Database PinmemberRobymon30-Sep-12 20:38 
AnswerRe: How to Recover Deleted rows from sql 2000 Database PinmemberEddy Vluggen1-Oct-12 0:57 
AnswerRe: How to Recover Deleted rows from sql 2000 Database PinmemberShameel3-Oct-12 5:46 
QuestionWindows Run Command Pinmemberjojoba201128-Sep-12 23:08 
AnswerRe: Windows Run Command PinmemberEddy Vluggen29-Sep-12 2:41 
AnswerRe: Windows Run Command PinmvpRichard MacCutchan29-Sep-12 2:58 
AnswerRe: Windows Run Command Pinmemberjojoba201129-Sep-12 5:12 
GeneralRe: Windows Run Command PinmvpRichard MacCutchan29-Sep-12 6:09 
QuestionRe: Windows Run Command [modified] Pinmemberjojoba201129-Sep-12 9:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140709.1 | Last Updated 10 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid