Solved

Problem to find out the detailed steps

Posted on 2014-11-25
11
187 Views
Last Modified: 2014-12-10
Hi,
Within the existing backup procedures (I mean the current documents that are giving details of the backup steps), I can see there're files with the extensions like .rcv, .bat. But I never see the detailed steps which are mentioning the steps to create the .dmp files. where can I find out the steps to generate the .dmp files?
0
Comment
Question by:HuaMinChen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
  • +1
11 Comments
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40466146
are you referring to windows dmp files (memory dump files)??
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40466174
I do not see the steps (in the relevant document) of the Backup procedure, which is to generate the .dmp files
0
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40466180
what document are you referring to ???
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 10

Author Comment

by:HuaMinChen
ID: 40466208
The one for our own DB backup procedure.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 40466273
we can't see your own backup procedure

in general .dmp files are create with exp or expdp
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40466279
I know, but I do not see such commands within .bat and .rcv files, which are doing the DB backup.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 40466283
neither can i
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40466326
where can I find out the details that are generating the .dmp file?
0
 
LVL 37

Accepted Solution

by:
Geert Gruwez earned 500 total points
ID: 40466490
it can come from anywhere
* someone can copy files to your server
* someone can start a batch, create any file and then rename the extension to .dmp
* it can come with a software installation
* al-jazeera installed a virus on your system which creates .dmp files

really from anywhere
> check the file properties, is there an author ? date created ?
any info ???
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40466710
As stated already, they really can come from anywhere.  We don't know your backup procedure.  Everyone's backups are unique.

In addition to other suggestions, they could be from a scheduled job within the database as well.

Personally, I don't like exports as backups.  You cannot roll them forward.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 40468549
as long as you don't provide details of your backup
we can 't give good advice
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question