Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Applications > SQL > Backup & Restore


Search:
What's New - What's Hot
Database Maintenance Plans and Backup File Management in SQL Server 2005     
Total Hits: 335  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database maintenance is vital to the health of an organization's data delivery infrastructure. In SQL Server 2005 Microsoft redesigned the method through which Database Maintenance Plans are created and managed. These plans can be created through a wizard in SQL Server Management Studio (SSMS). They are handled mainly through the Business Intelligence Studio (BIDS), and custom plans can be created in BIDS using SSIS. Although the process is comprehensive, the management of physical backup files ...

Why do my SQL Server database maintenance plan transaction log backups always fail     
Total Hits: 321  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

One nice feature of SQL Server is the ability to create maintenance plans for all different types of maintenance activities such as backups, index rebuilds, integrity checks etc... One part of the backup process is the ability to create transaction log backups. One thing you may have noticed is that when you set this up and the job runs it always fails. You check the backup files and the backup files are created, so why does this job always say it failed?...

How to stop logging all successful backups in your SQL Server error logs     
Total Hits: 234  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server error log is a great place to find information about what is occurring on your database server. One helpful thing that each log offers is that it shows you all of the failures and/or errors that have occurred since the last start of SQL Server or since the last time you cycled the error log. On the flip side of that, it also shows you success messages such as backups, logins, DBCCs, etc... Although this may be helpful to log all of this information it unfortunately clutters up ...

Maintenance task to delete old SQL Server backup files     
Total Hits: 294  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In two previous tips we discussed how to automate full backups and transaction log backups by creating scripts that iterate through each of your databases and then execute the backup commands. A reader requested information about how to automate the process of deleting older backup files, so this tip explains one approach for getting rid of older backup files that are generated....

CLR function to delete older backup and log files in SQL Server     
Total Hits: 249  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous tip we looked at how to put together a CLR function for sorting text data. In addition, we have also written tips about how to mimic the functionality of maintenance plans without having to use a maintenance plan. In one of these previous tips, "Maintenance task to delete old backup files" we outlined how to delete older backup files by using a VB Script. To take this deleting of older files a step further, this tip will look at this same task to remove older backup and log file...

COPY_ONLY Backups with SQL Server 2005     
Total Hits: 247  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

One issue with creating backups is that the LSNs (log sequence numbers) get stored in the backup files and these LSNs are referenced when you do a restore of your database. The reason the LSNs are stored with the backup file is to verify that the backup files are being restored in the proper sequence when you go to do your restores. The problem with having the LSNs stored with the backup file is that you can not do off schedule backups without affecting the LSNs of your regularly scheduled backu...

Do you really know if your SQL Server database backups are successful?     
Total Hits: 249  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Are you absolutely sure? Are you? After hearing a presentation from Microsoft's Paul Randall, at a recent Northern Virginia SQL Server Users Group session, I wondered how many DBAs\Developers\Network Admins realize their SQL Server database backups are failing. According to Paul they find out when it is too late - when they are experiencing corruption and facing lost data after significant amounts of downtime. Both of which are detrimental for the success of the organization and inexcusable ...

Getting exclusive access to restore SQL Server databases     
Total Hits: 247  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

A task that you may be faced with as a DBA is the need to refresh a test or development database on a periodic basis. This may be a scheduled process or it may be an ad hoc process. One of the things that you need to do when restoring a database is to ensure you have exclusive access to the database otherwise the restore process will not work. What options are there to ensure you have exclusive database access, so the restore process will work without issue?...

SQL Server 2000 Database Restores Mapping Users to Logins     
Total Hits: 234  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When restoring a database to a different server there is often the problem of matching up logins and users. The reason for this is that login information is stored in the master database and user information is stored in the specific database you are working with. The login information is stored in the sysxlogins table in the master database. This table contains a column that holds the SID (Security Identifier) which is tied to a specific login. A corresponding table sysusers is stored in each ...

SQL LiteSpeed     
Total Hits: 684  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL LiteSpeed is the new way of backing up SQL server databases quickly and securely. Unlike existing technologies, SQL LiteSpeed encrypts and compresses all data as it backs up, which means that cumbersome compression routines and poor encryption algorithms are a thing of the past. The size of the backup file is up to 15 % of the original database size, maximising storage efficiency and saving a fortune in disk space, while the state of the art 128 bit encryption algorithm ensures that data can...

Encrypt and safeguard your SQL Server database backups     
Total Hits: 236  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server backup process allows you to perform full, differential, transaction log and file level backups. The problem with all of these backups methods is that the data that is created in the backup is stored in clear text and can easily be comprised if someone cares to take the time to hack through these backup files. In addition, SQL Server makes it very easy for you to move a database from one server to another server by restoring a complete backup or by having the MDF and LDF files a...

Backup to multiple files for faster and smaller SQL Server backup files     
Total Hits: 255  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Have you ever wished you could get your backups to run faster? Well there may be a way, by writing to multiple files. Creating SQL Server backups is pretty simple to do; you can use the SQL Server management tools or you can use T-SQL commands to issue the backup. But sometimes with large databases it takes a long time to run and it is difficult to copy this very large file across the network or even to your backup tapes. Write your database backup to multiple files. In addition to writing yo...

Verifying Backups with the RESTORE VERIFYONLY Statement     
Total Hits: 209  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are a number of ways to make sure data in your organization is highly available, yet technology always seems to find a way of making data disappear. Data backups should be the cornerstone of every organization's disaster recovery plan. So, how do you know whether the backups are actually readable? One way is by issuing a RESTORE VERIFYONLY statement against the backup file. When backing up database files in SQL Server 2000 and 2005, the RESTORE VERIFYONLY statement is available to verify t...

Issues with running backup log with no_log or truncate_only     
Total Hits: 188  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

On my database server I have my databases set to the full recovery model, but the transaction logs get quite big, so I am issuing a BACKUP LOG with NO_LOG. I am not exactly sure if this causes any issues, but I know that I am able to free up space in my transaction log and shrink the file. Is this the correct way to handle this situation? When managing transaction log growth, the first thought that may come to mind is to use the NO_LOG or the TRUNCATE_ONLY commands....



Disclaimer - Privacy
© 2002-2017 DevASP.net