I need some guidance with OFFSITE backups for SQL SERVER. I remember using Veritas with Oracle in the past.
Please let me know what you are using/suggestions. Thank you.
View Complete Post
I have a maintenance plan that backups a bunch of databases every morning. I need to keep these backups for three days and then they are to be deleted to prevent the disk filling up. Ive ticked the box saying 'Backup set will expire after 3 days', but after
three days they are still there..
Anyone know how to remove them automatically?
I am a bit confused
with the first_lsn, last_lsn, differential_base_lsn in the msdb.dbo.backupset.I have
a sql server 2005 database in full recovery mode. My backup jobs are – nightly full backup, dfifferential backup every six hrs and log backups every hr. In addition to that I do do adhoc backups with copy_only.
Usually full bcakup takes 15 minutes, differential backup 5 minutes and
log backup under one minute.
Because they are scheduled to run on top of the hour, it is quite possible all three jobs are triggered at the same time. ( Full backups do not
block log backups, Not sure if same is tru with diff backups and log backup). In such a situation I want to see a complete sequence of backups what should be the ordering criteria?
I am using below query to get the backup sequence.
Should I order based on backup_start_date, F.family_sequence
Hello. I am planning to restore my dev database with differential backups from my production at least once a month. The situation is that the dev database would be updated during the month. What happens to the datas on dev after restoring the differential
backups from production? Is this even possible at all?
All I want is to have copies of datas accumulated over time from production coupled with the once I created on my deve.
Thanks in advance for your help
does Microsoft provide any stand alone utility which can verify a backup file for consistency?
I have plenty of backups being copied over to a network server. the network share does not have SQL installed. But I want to verify the backup copies.
Originally we had a 1 server standalone MOSS2007 install. (All service packs applied)
Then we added another server to the farm to act as a web server.
We decided to take the web server offline. So that ideally we would be back to our 1 server standalone setup. All our sharepoint sites still work fine after we did this, but things on the central administration side are horribly broken.
1. The web server still appears in farm topology even though it is offline, no longer exists. It also appears as "Windows SharePoint Services Database".
2. Trying to go into "Servers in farm" under Operations causes an unknown error.
3. Trying to go into "Timer job status" under Operations causes an unknown error.
The error log displays the following each time I try to access "Servers in farm" or "Timer job status"
OWSTIMER.EXE (0x199C) The following error occured while trying to read the ConnectionString property. Object reference not set to an instance of an object.
Now before I try to do some serious reconfiguration I would like to backup my sites. If I use the "Perform a backup" feature in central administration, it tells me the backup job has been scheduled, but after waiting for hours it still hasn't started,
and doesn't look l
I am working with SQL Express and found myself surprised when I tried to automate a backup...ÃÂ No Agent.
So I am trying to create a simple backup script to run from the command line and probably schedule through the scheduled task manager.
here is my problem.ÃÂ I get the following error :
Msg 2812, Level 16, State 62, Server FIREFLY\SQLEXPRESS, Line 1Could not find stored procedure 'B'.
Here is the batch file
sqlcmd -i c:\temp\test\DBbackup.sql -o c:\temp\test\output.txt -S FIREFLY\SQLEXPRESS
And here is the sql input file :
BACKUP DATABASE [DNNDEV] TOÃÂ DISK = 'C:\temp\test\dnndev.bak' WITH NOFORMAT, NOINIT,ÃÂ NAME = 'dnndev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,ÃÂ STATS = 10;
If I put a USE statement in front of my backup statement - the error message changes to
Could not find stored procedure 'U'.
So it would appear to list the first character encountered.
As a sanity check I created a similar process which does a select * from a table and I do not get an error saying :Could not find stored procedure 'S'. - instead all is well and I get my output and no error
If I try the backup command in SQLCMD interactively it works.
so what the heck am I missing ?
Thank you for any help...
Please help me with details on
1.how i can automate a job to go ahead and restore a specific database from one server to another every month so that i can be sure that the backups are valid.
2.Once done, I would like to run checks on it. Please provide a list of database validation checks that should be performed. Is a basic health check sufficient???
3.Send myself and email and drop the restored db.
Thanks in advance!
I am looking to perform a backup on a busy system. The database is around 30gig. Assuming it takes 15 minutes to back it up. A) How does sql server maintain db backup consistancy? B) Is there a big overhead involved?
Thanks in advance
I have a client who has been backing up their WSS3.0SP2 site using a SQL backup utility. The server their site runs on crashed and is unrecoverable so all I have are the sharepoint DB files. (WSS_CONTENT, ADMIN-CONFIG, etc).
Can someone point me in the right direction on how to connect these DB files to a new sharepoint server and get it running again?