|
How to automate your system database backup task using script.
|
Total Hit (3470) |
The following script will show you some powerful technique to script backup task for system/user database. Example also shows how to create one file which contains several backups which can expire at specified date.
«code LangId=6»--drop table #tmpDevice
create table #tmpDevice (device_name s
....Read More |
Rating
|
|
|
Restore the SQL Server master database
|
Total Hit (2792) |
Restoring a corrupted master database is one of the most difficult tasks you may have to deal with. If this catastrophic event happens, here's how to proceed.
First, you need to rebuild the master database. Details on this operation depend on the SQL Server version you run. With SQL Server 6.5 t
....Read More |
Rating
|
|
|
|
|
|
|
Get SQL Server Details ( Edition , License ... etc ).
|
Total Hit (2898) |
How to obtain details about the server using the new SERVERPROPERTY system function?
«code LangId=6»SELECT CAST( SERVERPROPERTY( 'MachineName' ) AS varchar( 30 ) ) AS MachineName ,
CAST( SERVERPROPERTY( 'InstanceName' ) AS varchar( 30 ) ) AS Instance ,
CAST( SERVERPROPERTY( 'P
....Read More |
Rating
|
|
|
Can I Backup Across the Network?
|
Total Hit (2546) |
You can backup over the network. I prefer to use UNC paths because mapping drives under SQL Server can cause some weirdness (Hmm... maybe an article on that).
My favorite method is to not even muck with backup devices:
BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\foo.bak' WITH INIT
....Read More |
Rating
|
|
|
SQL 2000 Install Generates PENDING FILE OPERATIONS Error
|
Total Hit (2832) |
When trying to install SQL Server 2000 on an NT machine sometimes you may receive the following error.
<font color=red><b>"A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."</b></font>
SQL Setup is
....Read More |
Rating
|
|
|
Change Object Owner
|
Total Hit (3395) |
This is very handy stored procedure which I use all time to change object owner. Many times you create object as a different user other than "dbo" and things start breaking. I use this sp to change owner off all objects to "dbo".
«code LangId=6»/*
This stored procedure can be used to run through
....Read More |
Rating
|
|
|
|
|
How to script SQL tables using SQL DMO
|
Total Hit (2252) |
«B»Introduction«/B»
SQL-DMO encapsulates SQL Server components and presents them as attributes of the component piece to you as properties of an object instance. You would have to alter the properties of the instance or use object methods to automate SQL Server administration. This article takes
....Read More |
Rating
|
|
|
SQL 2000 and Web Services (XML and SQL part 11)
|
Total Hit (932) |
In the last article of this series, we will focus on Web Services and their implementation in the SQL Server 2000 environment with the help of the SQLXML component. In particular, we will look into a non-programmatic way of publishing SQL Server 2000 stored procedures, user-defined functions and XML
....Read More |
Rating
|
|
|
|
Importing XML into SQL Server 2000
|
Total Hit (2359) |
One of the frequently asked questions on SQL Server newsgroups is "How to import XML data into SQL Server 2000?" There are various ways in which XML data can be imported into SQL Server 2000 database tables. In this article, we'll look at some of these options. More specifically, we'll explore the f
....Read More |
Rating
|
|
|
Shrinking Databases and Logs - SQL 7 and Higher
|
Total Hit (1865) |
SQL 7 and SQL 2000 allow automatic file growth. Therefore, the files can grow large. It is important to understand how to reduce the database and log files sizes.
There are two DBCC commands to help shrink databases and files. Both are needed to reduce and maintain file sizes.
....Read More |
Rating
|
|
|
XML and SQL 2000 (Part 7)
|
Total Hit (1059) |
We are ready to conclude the discussion on various methods of extracting relational data from SQL Server 2000 in XML format via HTTP. All methods described in previous articles are available through SQL ISAPI extensions to Internet Information Server, implemented as IIS Virtual Directory Management
....Read More |
Rating
|
|
|
Backing Up and Restoring SQL Server Databases and Transaction Logs
|
Total Hit (1130) |
The backing up and restoring of databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if media failure occurs or if the database is somehow damaged (for example, fro
....Read More |
Rating
|
|
|
Streamlining the Database Server Recovery Process on SQL Server
|
Total Hit (683) |
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this
....Read More |
Rating
|
|
|
Using and Building Query Analyzer Templates
|
Total Hit (703) |
The Query Analyzer (QA) in SQL Server 2000 is greatly enhanced over the QA in SQL Server 7.0. One of the enhancements, QA templates, can increase your productivity in developing code.
QA comes with over fifty canned templates that you can use. Although these templates are useful as they are insta
....Read More |
Rating
|
|
|
SQL LiteSpeed 3.0 -- The Smarter DBA's Backup
|
Total Hit (818) |
For almost two years, DBassociatesIT has produced SQL LiteSpeed, an alternative to SQL Server's native backup and restore commands, offering greater security, faster backup and restore speed, and smaller backup files resulting in significantly reduced storage costs. With the introduction of SQL Lite
....Read More |
Rating
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 1
|
Total Hit (890) |
This is the second tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services" to save time
....Read More |
Rating
|
|
|
|
|
|
|
|
How do I open a file package or template
|
Total Hit (945) |
In the save package dialog screen there are several Locations available. The Structured Storage File option is useful if you wish to keep the package as a file, perhaps so that it can be added into a source control repository, or for manually copying to another server or transfer media. Whilst it is
....Read More |
Rating
|
|
|
Failover Clustering
|
Total Hit (745) |
Continuous uptime in a production environment, whether it is a database powering a mission-critical client/server application or an e-commerce Web site, is becoming a common businesses requirement. This chapter describes Microsoft® SQL Server™ 2000 failover clustering, one method of creating high av
....Read More |
Rating
|
|