Can anyone recommend backup procedures for a SQL Server/MSDE product?
We have upgraded our program from Access to SQL & before we could just
tell our customers what .mdb files to include on their backup script.
Now with SQL, the BACKUP/RESTORE SQL commands work as backups, but
would involve a separate process for our customers to execute, when
what they know right know is to copy the .mdb files.
Is there a way they can backup the database files associated with our
program in SQL with whatever backup procedures they do? Would it be
reliable for them to just include the .mdf & .ldf files that go with
our database on their backup script - if they needed to do a restore
could they just copy that file back and the SQL/MSDE engines would
recognize it?
Our program is for SQL Server or MSDE - and in the MSDE case the user
would not know password to be able to manually run the Backup/restore
commands.
Thanks for any help,
Greg 1 2378
(gc****@nautico m.net) writes: Can anyone recommend backup procedures for a SQL Server/MSDE product? We have upgraded our program from Access to SQL & before we could just tell our customers what .mdb files to include on their backup script.
Now with SQL, the BACKUP/RESTORE SQL commands work as backups, but would involve a separate process for our customers to execute, when what they know right know is to copy the .mdb files.
Is there a way they can backup the database files associated with our program in SQL with whatever backup procedures they do? Would it be reliable for them to just include the .mdf & .ldf files that go with our database on their backup script - if they needed to do a restore could they just copy that file back and the SQL/MSDE engines would recognize it?
Normally, you cannot backup an SQL Server database with Windows
backup. This is because the backup would not be transactionally
consistent, if there is activity in the database while the backup
is running.
However, if you set the database offline prior to taking the backup,
or simply stop SQL Server, backing up the MDF and LDF files works
fine.
I don't know about Access, but reasonly the same applies there - you
cannot just copy thy MDB file, if there are activity going on.
Note that if you do with Windows backup, you must set the database in
simple recovery, so that the transaction log is regularly truncated.
Else the disk will explode after some time.
If you want up-to-the-point recovery, then there is no alternative
to SQL Server Backup. (Save for 3rd party softwares like LiteSpeed,
but that's targeted for bigger databases.)
Our program is for SQL Server or MSDE - and in the MSDE case the user would not know password to be able to manually run the Backup/restore commands.
They can always log in with Windows Authentication. And, unless you
drop BUILTIN\Adminis trators, the users can log with Admin privs.
I mention this, in case you believe that you have your intellectual
property by a password.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jean Hagen |
last post by:
Hi, I'm a new user of MySQL on Linux.
I have been an Oracle DBA; and know that anyone familiar with Oracle takes
backup procedures very seriously....
Anyone have recommendations for nightly backup procedures for MySQL
(transactional) databases? The literature seems a little ambiguous on this.
I did 'turn on' the general, binary and error logs. Does anyone shut down
the MySQL daemon regularly? Anyone use mysqldump, or do folks...
|
by: John Smith |
last post by:
Hi
I am currently reviewing our backup procedures. Part of the issue has been
finding the right fit. There are obviously backup products that provide
mysql agents but unfortunately can not for fill our complete backup/disaster
requirements. I have evaluated bakbone, arkeia, brightstor, veritas. I am
currently looking at evault, commvault and ipstor.
I am now looking to separate mysql from the rest of the backup. I am
looking to...
|
by: JustaCowboy |
last post by:
Greetings,
I am seeking information related to this subject.
BOL suggests backing up the active transaction log immediately after a
failure, so that the backup can be used in a recovery scenario if necessary.
This is the relevant text from BOL "Transaction Log Backup":
----//
The transaction log backup created at 8:00 P.M. contains transaction log
|
by: mediodia |
last post by:
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
·"Full Path\Name.MDF is not a primary database file." (This is one of
|
by: Raquel |
last post by:
I am a newbie to UDB and reading the backup processes on UDB which
look pretty good to me. Now, if these good backup and recovery
procedures are already available 'within' UDB, what extra convenience
and feature do products such as TSM etc. provide?
For example, if I am using 'native' UDB (without TSM etc.) for all my
backup/recovery needs, I appreciate that I must be pretty thorough
with my understanding of recovery related concepts so...
| |
by: UnixSlaxer |
last post by:
Hello,
- I have a database, which i want to backup, not only the data, but
also the indexes and views/procedures associated with it. Is the
backup/restore operations (Through the DB2 Control Center) sufficient ?
- And what happens if I later on add an index, and then restore the old
database, will this new index/view be removed ?
Any help would be appreciated.
|
by: Nesa |
last post by:
I have a question related to backup and restore procedures; When
backing up and then restoring a DB2 database on another machine, does
the process copy all of user defined store procedures and functions
over to the target machine?
I would assume everything would be copied to the target machine
including data, metadata, as well as other database objects including
stored procedures and functions, however I have seen a post in this
group...
|
by: Steve F |
last post by:
i have a copy of a SQL Server 2000 database on an external hardrive.
I have SQL Enterprise Manager 2005 on my laptop and was wondering if
it is possible to view the backup on my laptop when external hard
drive is plugged in.
What other software/tools/procedures do i need to do to make the
backup "viewable"
Regards
|
by: mgpsivan |
last post by:
Hi,
How can we backup or restore a database with all its tables,procedures,views,triggers etc., when i tried using mysqldump command i'm able to backup the tables and procedures alone.But restoring it is still a ? Can any one help me with this problem. Please let me know the way to backup and restore the complete database.
Thanks
Sivan.G
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |