|
|
|
|
|
| | Total Hits: 139 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| | 
One problem with SQL Server 2005 Express is that it does not offer a way to schedule jobs. In a previous tip, Free Job Scheduling Tool for SQL Server Express and MSDE, we looked at a free tool that allows you to create scheduled jobs for SQL Server. The one issue people often face though is what to install and what not to install on their production servers and therefore these items go without resolution. One very important part of managing SQL Server is to ensure you run backups on a set sch... |
| | Total Hits: 153 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Have you ever had the need to replace multiple words in a data column within SQL Server with a new word or a new phrase for an entire table? A good example would be to update a product catalog with new words either for standardization or just to reflect a new name for the product. A simple technique would be to use the REPLACE command as outlined in this prior tip. This is great if you only need to update a few words, but what if you need to scan the entire product catalog and make several ch... |
| | Total Hits: 153 | Today: 0 | Author: Narayana Vyas Kondreddi | Rating: |
| |
This is one of the common requests I see in the newsgroups. People often wonder how they could search and replace data, that is stored in their tables. While this doesn't sound like a very good thing to do, there are some genuine situations, where 'find and replace' functionality is needed. For example, spelling mistakes in the column values, or moving a database from one location to another, and wanting to replace all location specific content.
Is there a built-in 'Global Search and Replace'... |
| | Total Hits: 522 | Today: 0 | Author: Shabdar Ghata | Rating: |
| |
Whenever we want to backup or move SQL Server database, most of us prefer to use regular backup utility which is available through Enterprise Manager in SQL Server 2000 or Management Studio in SQL Server 2005. Limitation of using Enterprise Manager or Management Studio is we have to use either complete or differential backups. This is a very tedious task when we want to backup only a small portion of a large database. For example, in my database I would like to take backup of only 15 tables out ... |
| | Total Hits: 174 | Today: 0 | | Rating: |
| |
While I right away want to say to you - I'm not getting into the "what's-best-MySql-or-Sql-Server"-war with this article - instead I just wanted to tell you what happened to me and my clients lately and how surprised I was to see that both MySQL and MS SQL Server 2000 solved my problems pretty easily. This is also a true story which points out some things to pay attention to when it comes to backing up data.... |
| | Total Hits: 3 | Today: 0 | Author: Joe Chang | Rating:  |
| |
For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high–end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. All of the tests were conducted using publicly available tools, and can be reproduced with reasonable accuracy.... |
| | Total Hits: 82 | Today: 0 | Author: Pinal Dave | Rating: |
| |
This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore.
1. Conventional Backup and Restore
2. Spilt File Backup and Restore
3. Mirror File Backup
4. Understanding FORMAT Clause
5. Miscellaneous details about Backup and Restore... |
| | Total Hits: 133 | Today: 0 | Author: Armando Prato | Rating: |
| |
In one of your recent tips, you mention that SQL Server keeps a history of all backups and restores that have been made in the system. Our organization performs backups and restores frequently and I've noticed our msdb database is very large because of this. How can I purge some of this data and free some database space?... |
| | Total Hits: 116 | Today: 0 | Author: Shabdar Ghata | Rating: |
| |
It has been a year since I wrote this article. I got many responses for this backup utility. So I decided to update this program and made major changes to make it more stable in terms of functionality and performance. You can read my original article, SQL Server Backup Utility (Old Version).
Following is a list of changes for a new version:
* Backup file extension is now .ZIP instead of .SQLBackup. This is to avoid any confusion.
* Old version was having an issue with restoring ... |
| | Total Hits: 53 | Today: 0 | Author: Joshy George | Rating: |
| |
It is a sample C# (VS2005) application for Automatic Sql server Backup Utility using sqlserveragent. I have used SQL-DMO dll. This article will show you how to create a automatic backup in Sql server 2000. This code should work on any PC use VB.NET and installed SQL Server 2000 (any edition or Client Components for SQL Server 2000.... |
| | Total Hits: 99 | Today: 0 | Author: Andy Novick | Rating: |
| |
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability. One of the useful features of the BULK provider is its ability to read individual files from the file system into SQL Server, such as loading a data from a text file or a Word document into a SQL Server table. This capability is the subject of this tip.... |
| | Total Hits: 68 | Today: 0 | Author: admin | Rating: |
| |
From your Windows Forms application, implement two menu commands
a) backup entire MySQL database, compress it and send it with FTP to a ftp server
b) reverse = fetch from FTP server, uncompress, restore to MySQL
Kind of open/save functionality for my database app. Why? A way for me to be more mobile. At night I wanna be able to solve my backup problem easily from within my main business app just by selecting "Backup" or even "Save" in my menu and the next day I might be travelling, so f... |
| | Total Hits: 190 | Today: 0 | Author: Atif Shehzad | Rating: |
| |
Database backups hold primary importance among daily DBA tasks. This task is typically automated through maintenance plans, scheduled SQL Server Agent Jobs or third party tools. With the importance of backups it is necessary to regularly analyze the performance and efficiency of the process. So how can we get insight into the performance of a backup process for any database?... |
| | Total Hits: 127 | Today: 0 | Author: Tim Ford | Rating: |
| |
Recently I constructed a new backup process that I want to institute globally across all my SQL Server 2005 instances. This backup process will not only backup all the databases I point it towards, but at the same time will script out the backup commands to a single file in the format of F_YYYYMMDD.sql if the backup process is a full database backup or D|T_YYMMDD_HHMMSS.sql if the backup process is a differential (D) or transaction log (T) backup. These script files are then stored in a subfol... |
| | Total Hits: 119 | Today: 0 | Author: Ken Simmons | Rating: |
| |
There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database? The best way to make sure you have the proper restore scripts when the time comes is to make use of PRINT statements and OUTPUT files. Every time your backup job runs, whether it is a Full or Log, place a step at the end of the... |
| | Total Hits: 39 | Today: 0 | Author: funklet | Rating: |
| |
This small c# program will backup the SQL Database you specify and then upload them to the FTP server. It will also delete the backups from a specified number of days old except on the specified day eg. Keep Sunday, so that you are left with daily / weekly backups. You will have a daily backup for x days (e.g. 14) and a weekly backup that you can keep indefinitely. The backups are named DatabaseName_full_YYYYMMDD.bak The program can be altered easily to change these parameters. The problem is ... |
| | Total Hits: 168 | Today: 0 | Author: Edwin Sarmiento | Rating: |
| |
Database backups and maintenance windows for very large database are very frustrating especially if we need to generate full database backups to initialize a database mirroring or transaction log shipping session. As we are looking through the new features in SQL Server 2008 we found a potentially interesting one called Database Backup Compression which we can use to significantly reduce our backup and restore operations. Can you give us a detailed explanation of how we go about using this one?... |
| | Total Hits: 168 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One issue when creating backups for SQL Server databases is that these backup files can be restored to any other SQL Server as long as the version of SQL Server supports the backup file that you are trying to restore. In most cases this is not an issue unless you are trying to restore a backup from 6.5 or earlier onto a SQL Server 7.0 or later installation. Because of this ability to restore the backups to any other SQL Server this exposes your data to potential theft or misuse of your data. ... |
| | Total Hits: 125 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One of the first things that should be done when managing SQL Server is to setup an appropriate backup plan in order to minimize any data loss in the event of a failure. Along with setting up a backup plan there are certain database configurations that need to be setup to ensure you are able to backup databases correctly. In this tip we will look at the different recovery models that SQL Server offers and how to choose a recovery model for your database.... |
| | Total Hits: 170 | Today: 0 | Author: Rob Fisch | Rating: |
| |
SQL Server 2005 Analysis Services does not offer any straight forward way to automate backups for its databases. There are no objects in the Maintenance Wizard or Integration Services for this task. Even the Analysis Services built-in (right-click) backup option has no automation or job scheduling options. So how can you setup an automated task to back up your analysis services databases?... |
|
|
|
|
|
|
|
|
|
|
|
|
|