July 7, 2009 at 5:55 am
Hi,
My client needs take every day backup of dababase in server,how can we take backup of databse in client system,evey month client need fullback and everyday he needs back up of database which is form last backup.
I'm new to database administrations,If I'm using Tasks->backup it shows sever path,I need maintain the database backup in my local system any body help me
Thank you in advance
July 7, 2009 at 7:48 am
You need to find out "Why backups need to be stored on local machines?"
Databases should be backed up and sent to an off-site location or a designated DR site and not on users machines.
July 7, 2009 at 8:04 am
not sure exactly what you are looking for, sounds like you want to backup the database from the server to your client machine?
if so then create a job and set a schedule to do the following...this will back up to what ever network drive that you have created.....hope this helps
BACKUP DATABASE [TestDB] TO DISK = N'\\DatabaseBAK\TestDB_backup.bak'
WITH NOFORMAT, INIT, NAME = N'TestDB_backup'
GO
July 7, 2009 at 8:15 am
SA is correct. Backups should be maintained at some disaster recovery site.
Anyway you can click on add then on radio tab click on file name and then browse to the correct folder where you want your backup to be saved.
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 7, 2009 at 8:27 am
Suresh Mediboyina (7/7/2009)
Hi,My client needs take every day backup of dababase in server,how can we take backup of databse in client system
you can create a shared folder on client's machine and take your backup directly over there however this is not a good idea.
Instead, You should take backup on the server and then copy it over to clients machine on a daily basis. You can create an automated job to take backup and copy the backup file to client's shared folder.
evey month client need fullback and everyday he needs back up of database which is form last backup.
From your requirements, it seems your client is asking about FULL backup once a month and differential backup on a daily basis.
You can do these as suggested above.
However, more important question is "What is the backup/recovery strategy?" Since there is no mention of any log backup, you'll lose entire day's data in the event of a failure. Can you company sustain that loss?
We need more information on your scenario so that the best can be suggested.
July 7, 2009 at 8:43 am
What kind of infrastructure exists between the user and the server?
I suspect if they are on different networks then you are going to have to use VPN or FTP to transfer the backups
I would advise against allowing the client to backup the database whenever they feel like it (imagine they back up your database in the middle of an upgrade)
I would suggest creating a standard maintenance plan for this , or a scheduled job with the backup command listed in one of the earlier posts.
i would also advise if it is a lrge database then get a file compression tool (we use WinRAR as it can be called from the command line) and send a .zip file.
also consider security - you might be tempted to email the backup if it is very small, but make sure if there is sensitive data in the database that you encrypt the file first (and don't write the decryption key in the contents of the email)
MV
MVDBA
July 9, 2009 at 7:41 am
Hi,
A)
MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)
B)
MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups
C) I need a rapid DSL line in my company and with the client server
MyServer --> MyDSL --> Internet(VPN if possible) --> MyClientDSL --> MyClientServer --> MyClientHardDrive (This side is a client responsability if you aren't administering his system)
D) If you need to do a recovery from a backup, you could put recover data directly into client PCs. Or client can do it with his own recovery software
July 9, 2009 at 7:42 am
Hi,
A)
MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)
B)
MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups
C) I need a rapid DSL line in my company and with the client server
MyServer --> MyDSL --> Internet(VPN if possible) --> MyClientDSL --> MyClientServer --> MyClientHardDrive (This side is a client responsability if you aren't administering his system)
D) If you need to do a recovery from a backup, you could put recover data directly into client PCs. Or client can do it with his own recovery software
July 9, 2009 at 7:42 am
Hi,
A)
MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)
B)
MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups
C) I need a rapid DSL line in my company and with the client server
MyServer --> MyDSL --> Internet(VPN if possible) --> MyClientDSL --> MyClientServer --> MyClientHardDrive (This side is a client responsability if you aren't administering his system)
D) If you need to do a recovery from a backup, you could put recover data directly into client PCs. Or client can do it with his own recovery software
July 9, 2009 at 7:43 am
Hi,
A)
MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)
B)
MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups
C) I need a rapid DSL line in my company and with the client server
MyServer --> MyDSL --> Internet(VPN if possible) --> MyClientDSL --> MyClientServer --> MyClientHardDrive (This side is a client responsability if you aren't administering his system)
D) If you need to do a recovery from a backup, you could put recover data directly into client PCs. Or client can do it with his own recovery software
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply