Home > Default > Offline Backup in SQL Database using DB13

Offline Backup in SQL Database using DB13

October 11Hits:1
Advertisement
Hi experts,
I am new to MSSQL database.
We are using ECC 6 with MSSQL 2005. In DB13 we get the following options.
Full Database backup
Diff DB backup
Transaction Log Backup
Check DB consistency
We do not have the option to take a offline backup from DB13.
My question is, weather it is possible to take a offline backup in MSSQL.
If yes could please give me the procedure for doing a offline backup using DB13.
Thanks in advance for the response.
Regards
Anil

Answers

Lol, No by definition SAP and SQL would need to be down to take that type of file backup.
Offline backups are not a supported recovery method.
Online backups will allow for PIT or full recovery.
Offline backups will not be report in SQL or SAP as you haven't backup the database - rather just the files.

Read other 4 answers

Tags:

Related Articles

  • Offline Backup in SQL Database using DB13October 11

    Hi experts, I am new to MSSQL database. We are using ECC 6 with MSSQL 2005. In DB13 we get the following options. Full Database backup Diff DB backup Transaction Log Backup Check DB consistency We do not have the option to take a offline backup from

  • Offline backup failing when scheduled using DB13October 11

    Hi,            We have done our backup schedule of our BI 7 system running on AIX 5.3 and Oracle 10.2 using DB13.The activities like online backup and datbase check is executing correctly but offline backup is failing with status unknown. If i check

  • Offline copy of SQL Database in Visual Studio Community Edition?November 30

    I'm using an Azure Mobile Service and SQL database, and I'm interacting with it via Visual Studio Community Edition (12.0.31101.00 Update 4). I'm often offline, but want to work on and test the SQL code.  Is there a way to sync a local copy of the da

  • Help needed with secondary DPM backup of SQL databasesNovember 30

    I am having difficulties with some SQL databases not backing up to my secondary DPM server. a number of them are in "Replica is inconsistent" state and a few are in "Recovery Point creation failed" state though they are all OK on the p

  • Backup Huge SQL Database (500GB) and copy it to a 3rd party system.November 30

    Hello All, I have a situation as explained below: 1. Backup a 500gb sql database (can the backup be split into multiple files). 2. Copy it over the network to a third party datacenter (in a different network), in the safest way. Assuming i will have

  • How to schedule backup on SQL database backendNovember 30

    Hi, We have installed CRM5.0 on SQL2005 database at first time. My concern is in oracle database we schedule through DB12 twi types of backup Onlie and offline. But in SQL backend how many types of backup? is that same like online and offline. Can we

  • Backup of sql database grows rapidlyNovember 30

    Hi, We have issue with respect to log's over MSSQL, due to logs the size of the database is increasing rapidly. Can you please provide the best solution as what needs to be done. Thanks, Chetan KrishnaHi, IMHO  more appropriate term would be :taking

  • Configure Offline Backup using db13November 30

    Hey Experts, I am new to db2. Currently the database is running in nolog mode. So only offline backup can be taken. But Offline backup cannot be scheduled using db13 for db2. I need help to change the parameters in db2.Currently the databse is in no

  • Splitting large sql database filesNovember 30

    Hi I have large sap sql server data files having size in 40 GB/ 3 data files. Is there any way to split those data files into smaller size  . Thanks and Regards JijeeshHi Jijesh, There is a way of splitting files without hampering performance, I have

  • How to perform a Oracle-Offline-Backup started from within SAP in ClusterNovember 30

    Hello, I didn't find a solution on web (at SAP/SUN/newsgroups) for the following problem: environment - offline-backup of Oracle-database (database of an SAP-R/3 ERP-system) - Sun Cluster 3.1 environment (SUNW.oracle_server:3.1, SUNW.oracle_listener:

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.823 s.