.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

OFFSITE BACKUPS Tape/Disk Backups

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

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


More Related Resource Links

Can I safely perform full backups without breaking log shipping? Can I do point in time restores if

  
I'm building a system using SQL Server 2008. I have log shipping set up across our WAN, and that's working fine. I need to perform local backups on the primary server so that I'm not relying on the (slow) WAN if it needs to be recovered from a server crash. Ideally, it would be nice to be able to perform point in time restores. I understand that I can use the transaction log backups, created for log shipping, to restore from. But I still need a full backup to start the restore from - and there seems to be some confusion regarding whether or not performing a regular full backup on the primary server will affect log shipping. Even on these forums, conflicting advice has been given, with some people saying it's fine as long as you don't do transaction log backups, and others saying you must run COPY ONLY backups (though they were talking about Server 2005). From what I understand, you can't do point in time if you use copy-only backups. I'm getting the impression that this used to be a problem under 2005, but under 2008 you can safely perform full backups while log shipping is running. Can anyone confirm my understanding before I make a career-altering error? :)

SQL Server 2005 Log Shipping and subsequent FULL backups that are needed

  
Afternoon,   I have a few Log Shipped DBs that are working great.   Currently they are set to fire off every 15 minutes 24/7.   My question is this ... I need to get FULL backups of the source DBs in order to restore them on certain Dev boxes.   If I were to execute the full backup on one of these Log Shipped DBs ... how would it affect the log shipping process?   Is there a special method to accomplish this?   As a side note, what would be some concerns/issues if in being able to create the FULL backups and not interupt log shipping, I were to create the backup using a 3rd party tool like Quest LiteSpeed?   I sure wish we were on Enterprise, then I could create a mirror and then snapshot off it to create my backups BUT ... that is not the case as we stand today.   Thanks

What type of backups create a LSN No.?

  
What type of backups create a LSN No.?"SQLSERVER DBA" "INDIA"

Large transaction log files after backups

  
I have noticed that the size of the transaction logs on my databases have rocketed lately, I do have full and differential backups in place for the databases in question, any reason for the sudden increase in size and is there anything that I can do to mitigate it. Some of the databases have a simple recovery model on, in which case transaction logs shouldn't be maintained, but I note that the sizes are still huge and this only started when I began taking full backups and differentials. Thanks.

SQL Backups

  
I have been thrown into doing some SQL work which i am not a pro at. I have a script setup to backup the database to a file called Backup.bak on a network location. Everything works fine BUT it keeps adding the backups to the Backup.bak file so it keeps growing larger and larger. I only want to keep 7 ays worth of backups for this particular script. My question is how can i use the script to keep only 7 days worht of backups and keep the backup.bak file from growing and growing. Right now i have to go in and delete the file every 7 days for it to start over, if i dont the backup file gets really really big.

Expire backups to prevent them from being restored

  
I have a client with a requirement that states data can only be retained for a certain amount of time.  After the time expires, the data is deleted from the database and cannot be retained or available.  While the data is no longer in the database, it would still reside in a backup taken prior to the expiration.  Is there any way to prevent a backup from being used to restore a database after a point in time.  Using the Expiration Date or Days Retention, only specify the backup can be overwritten.  Is there any way at all to invalidate the backup after a period of time so that it can no longer be restored?

making backups expire after 3 days automatically

  

Hi,

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?


How to find the sequence of backups from msdb.dbo.backupset

  

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

How to find the sequence of backups from msdb.dbo.backupset

  

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

restoring differntial backups

  

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

 


Standalone utility to verify backups

  

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.


Getting unknown errors in central administration. Site backups always fail. OWSTimer Errors.

  

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

Backups from SQLcmd ??

  

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 1
Could 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...

 


Automate Monthly Restore To Verify Backups

  

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!


Best Practices for SQL Backups - Snapshots vs Replay Manager vs SQL Maintenance Plans vs Backup Exec

  
Hi, can anyone give me some information on the best practice for backing up sql backups?  For example, is it better to use snapshots vs SQL Maintenance plans, etc.  Any info is greatly appreciated.

Thank You!

Backups

  

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 backups of the SQL dbs but that's it. How can I get the site running again?

  

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?

 

Thanks,


Teenage angst has paid of well, now I'm bored and old.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend