dcsimg
Results 1 to 3 of 3
  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    1

    Question What happened to the document from the SQL program?

    I applied for help in the technical department, but my problem has not been solved yet. Because of this, I may have problems with my business reputation. After unsuccessful editing, the file began to open with an error stating that the data was not found. What can I do now? I canít do without these data.

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    98,938

    Re: What happened to the document from the SQL program?

    I doubt anyone else has any better idea of what you're talking about than I do.
    After unsuccessful editing, the file began to open with an error stating that the data was not found.
    That means basically nothing to us. We have no idea what file, what data, what editing or how that error is being generated. All we can tell you based on that is that the data has not been found so you need to either fix the data so that it will be found or fix the code so that it will find the data.

    Please assume that we have no prior knowledge of your specific project, because we don't. Provide a FULL and CLEAR explanation of the problem, which would include EXACTLY what you're trying to do, EXACTLY how you're trying to do it, EXACTLY what happens when you try and EXACTLY how that differs from your expectation.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  3. #3
    New Member
    Join Date
    Jun 2018
    Posts
    1

    Re: What happened to the document from the SQL program?

    Here are represented the models of sql recovery - https://www.mssqltips.com/sqlservert...covery-models/

    It is the address of the guide below: https://www.mssqltips.com/sqlservert...storing-state/

    Restore full backup WITH RECOVERY
    As mentioned above this option is the default, but you can specify as follows.
    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' WITH RECOVERY GO

    Recover a database that is in the "restoring" state
    The following command will take a database that is in the "restoring" state and make it available for end users.
    RESTORE DATABASE AdventureWorks WITH RECOVERY GO

    Restore multiple backups using WITH RECOVERY for last backup
    The first restore uses the NORECOVERY option so additional restores can be done. The second command restores the transaction log and then brings the database online for end user use.
    RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' WITH NORECOVERY GO
    RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN' WITH RECOVERY GO
    Last edited by si_the_geek; Jun 16th, 2018 at 05:15 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width


×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.