Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
2) backing up an individual database
3) Securing the transaction on the hour as a mile stone to return to in the
event of error or system failure.
Thanks
Mark
5  1968 
Hi
The first place to start is Books Online:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m
insql.chm::/ad_bkprst_9zcj. htm
John
"mark" <ka******@on.ai bn.com> wrote in message
news:uF******** ****@newsfep3-gui.server.ntli .net... Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
2) backing up an individual database
3) Securing the transaction on the hour as a mile stone to return to in
the event of error or system failure.
Thanks
Mark
Standard Answer then. Thanks for NO help
"John Bell" <jb************ @hotmail.com> wrote in message
news:b8******** *************@n ews-text.cableinet. net... Hi
The first place to start is Books Online:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m insql.chm::/ad_bkprst_9zcj. htm
John
"mark" <ka******@on.ai bn.com> wrote in message
news:uF******** ****@newsfep3-gui.server.ntli .net... Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
2) backing up an individual database
3) Securing the transaction on the hour as a mile stone to return to in
the event of error or system failure.
Thanks
Mark
"mark" <ka******@on.ai bn.com> wrote in message
news:iu******** *****@newsfep3-gui.server.ntli .net... Standard Answer then. Thanks for NO help
What about the standard answer don't you like?
With more detail:
1) For backing up the actual installation, I generally find it easier to
reinstall the application if need be.
2) Backing up individual databases, look into creating a maintenance plan.
Or roll your own and use backup database as appropriate.
3) use BACKUP LOG on the required databases.
I'd also recommend getting a book on high availabilibity. The one from MS
press is quite good.
"John Bell" <jb************ @hotmail.com> wrote in message
news:b8******** *************@n ews-text.cableinet. net... Hi
The first place to start is Books Online:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m insql.chm::/ad_bkprst_9zcj. htm
John
"mark" <ka******@on.ai bn.com> wrote in message
news:uF******** ****@newsfep3-gui.server.ntli .net... Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
2) backing up an individual database
3) Securing the transaction on the hour as a mile stone to return to
in the event of error or system failure.
Thanks
Mark
Thankyou
"Greg D. Moore (Strider)" <mo*****@greenm s.com> wrote in message
news:7o******** **********@twis ter.nyroc.rr.co m...
"mark" <ka******@on.ai bn.com> wrote in message
news:iu******** *****@newsfep3-gui.server.ntli .net... Standard Answer then. Thanks for NO help
What about the standard answer don't you like?
With more detail:
1) For backing up the actual installation, I generally find it easier to
reinstall the application if need be.
2) Backing up individual databases, look into creating a maintenance plan.
Or roll your own and use backup database as appropriate.
3) use BACKUP LOG on the required databases.
I'd also recommend getting a book on high availabilibity. The one from MS
press is quite good.
"John Bell" <jb************ @hotmail.com> wrote in message
news:b8******** *************@n ews-text.cableinet. net... Hi
The first place to start is Books Online:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m insql.chm::/ad_bkprst_9zcj. htm
John
"mark" <ka******@on.ai bn.com> wrote in message
news:uF******** ****@newsfep3-gui.server.ntli .net...
> Hi
>
> I'm hoping that some could point me in the right direction for "best
> practice" in:
>
> 1) securely backing up a complete sql7 and 2000 server containing
many > databases.
>
> 2) backing up an individual database
>
> 3) Securing the transaction on the hour as a mile stone to return to in the
> event of error or system failure.
>
> Thanks
>
> Mark
>
>
"mark" <ka******@on.ai bn.com> wrote in message
news:uF******** ****@newsfep3-gui.server.ntli .net... Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
1.1) Schedule a complete backup of all production databases and include
the system databases master, msdb, model at some appropriate
timeslot.
To do this for the first time, try using Enterprise Manager, select
the
"schedule" option and then examine the TSQL code in the scheduled
task. Modify the schedule times to suit your operations.
1.2) Take a copy of the backup files offsite.
2) backing up an individual database
As above, so here below ... much like the
Hermetic tradition.
3) Securing the transaction on the hour as a mile stone to return to in
the event of error or system failure.
You will need to examine the differential backup strategies available
and gauge the best approach for this method in relation to your data.
The M$ documentation is not too bad at all if you are prepared to
go and experiment and learn by practice the operations therein
documented, and I'd be surprised if step by step instructions on
all of the above are not clearly established within it.
Pete Brown
Falls Creek
OZ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hlpl |
last post by:
Hi
I have a VB.net windows application that uses an MSDE database
I need to give the user the option to backup this data (and later restore it). Ideally I want to back the data up to an empty Access 2000 database that contains the table structure
I know that I can do this by stepping through each record of each table in MSDE, inserting them into the correct Access table, but i recon this will take a long time and is not very efficient
...
|
by: J. Frank Parnell |
last post by:
hello, i dont know asp at all, but i have been asked to backup a database
that is used on a site which uses .aspx.
i dont need to do anything with it, just copy it and send it along to
someone who will. I have the IP, username, password.
i have allready got all the files off the site with ftp, is the database in
there? i dont really even know what i'm looking for, but i dont see any .mdb
or .sql right off the bat.
|
by: Jerry Porter |
last post by:
Is there a way to back up the design changes in a SQL Server database
without backing up all the data? It's just test data at this point.
|
by: war_wheelan |
last post by:
I am having a problem backing up my database and TLog files due to a
lack of local diskspace. The db file is about 30GB and the TLog is
about 20GB each on a different hard disk. Each disk doesn't have
enough available space to accomadate a backup. I also can't shrink the
files because part of that procedure would require a backup.
Question: Can I use a redirected drive for the backup media? Is there
a way to trick SQL into allowing...
|
by: Pavs |
last post by:
This may not be the place to ask however i am looking for resources on
how i may document data I am backing up from an oracle database to MS
Access.
Basically I have my oracle database and i have an Acess database.
I have to back up 3 tables from oracle into access.
I have no idea how i would document this.
| | |
by: Lyle Fairfield |
last post by:
I have posted previously a procedure for backing up a remote MS-SQL db
as text. This is a revised version in Javascript/JScript. This backups
data and procedures as XML.
My purpose in creating this is to preserve my data in simple form. When
one rents a remote MS-SQL db, one may find that getting a backup is more
expensive than the renting.
One could add other parts, say indexes, of the db to this procedure
quite easily. I want only those...
|
by: Stewart Graefner |
last post by:
I would like to know if an Access db can be backed up with the push of a
command button. I work with extreamly lazy operators who despite
crashing their db's still refuse to see the value in backing up their
db's. Fools them..but its me that has to undo the boondogal. I would
like to be able to put a buttom on the form which will send the a copy
of the db to another drive, perhaps a USB stick. Any ideas?
*** Sent via Developersdex...
|
by: Martin Schmid |
last post by:
I am developing using Visual C#.net. It appears that my web projects create
files in both "My Documents\Visual Studio Projects" and ".\inetpub\webroot".
Does backing up these files ensure that my code is all backed up? Is there
a backup/restore FAQ somewhere?
--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
|
by: Martin Schmid |
last post by:
I am developing using Visual C#.net. It appears that my web projects create
files in both "My Documents\Visual Studio Projects" and ".\inetpub\webroot".
Does backing up these files ensure that my code is all backed up? Is there
a backup/restore FAQ somewhere?
--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
