How to restore SQL Server 2000 backup file
Within Enterprise Manager right click on Databases, select All Tasks, then select Restore Database, or you can usethe <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-restore-database-command/”>Restore Database</a> command.

View Answer   |  March 1, 2009  8:24 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server backup

SQL Server 2005 database mirroring over a VPN router
This question was posted <a href=”http://go.techtarget.com/r/5981650/2258499/9″>here</a> as well. The answer is still the same. Yes, database mirroring can be used between buildings and/or over a VPN. Just make sure that the amount of bandwidth that you are using is less than the amount of bandwidth available over the link between the buildings.

View Answer   |  February 27, 2009  7:19 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers

Attaching MDF and LDF files to SQL Server 2005
Where the MDF and LDF detached from the SQL Server at the same time, if they were then you can attach them using the sp_Attach_db system stored procedure. However if they were detached at two different times they there are useless together. You can attach the MDF file without the LDF File by using the [...]

View Answer   |  February 27, 2009  7:14 PM
LDF, MDF, SQL Server 2005

Slowdown in SQL Restore on SQL Server 2000
This is because the SQL Server doesn’t remove the information about the old backups which have been taken. When you bring up that Window the SQL Server is pulling up the information for every backup that has ever been taken on the aserver. To remove backup history use the sp_delete_backuphistory system stored procedure in the [...]

View Answer   |  February 27, 2009  6:58 PM
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, SQL Server performance

SQL Server password issues
You can’t access a SQL Server without a password. You can change the password of a SQL account using sp_password. Windows logins passwords would be changed at the Windows Domain level by the user. The SA account is a default account which is created when the SQL Server is installed. This account has full access [...]

View Answer   |  February 27, 2009  5:01 PM
SQL Server administration, SQL Server Password Management, SQL Server security, SQL Server System Administrator

Converting data to SQL Server data with the DTS wizard
Try to transfer the data to a non-existing table in SQL Server and see how the DTS package creates this column in the new table (which datatype). If the data is then transferred properly, use this “temporary” table to hold the data and insert the data to the real table using an insert statement, in [...]

View Answer   |  February 27, 2009  4:37 PM
DTS Import/Export Wizard, DTS Wizard, SQL Server, Sybase

SQL DB MIRRORING ACROSS VPN?
Yes, database mirroring can be used between buildings and/or over a VPN. Just make sure that the amount of bandwidth that you are using is less than the amount of bandwidth available over the link between the buildings.

View Answer   |  February 26, 2009  7:13 PM
SQL, SQL database replication, SQL Server Database Mirroring, VPN

Job permissions in SQL Server Agent
Thanks for the help. I was researching this online and it seems that SQL 2000 needs Service Pack 3 for TargetServersRole. Is this true?

View Answer   |  February 26, 2009  8:57 AM
SQL Server 2000, SQL Server Agent, SQL Server Agent job permissions, SQL Server user permissions, SQLAgentReaderRole

Choosing a version of SQL Server on a laptop with Windows Vista
It really depends on a couple of things: First, what version of Vista are you using? Second, how much horsepower do you have. I hae a newer Alienware machine and havce both SQL2005 & SQL2008 running on it. If I were you, I’d go with 2008. If it seems to slow your machihne, you may [...]

View Answer   |  February 25, 2009  11:55 PM
SQL Server, Windows Vista

Mapping files into SQL Server databases
How are you loading these files into the SQL Server? For something like this it is recommended to use the BCP command line tool. When using BCP use the -b flag to have it process the records in smaller batches. This way it will commit the records in small groups instead of trying to commit [...]

View Answer   |  February 25, 2009  11:53 PM
SQL Server Database File Mapping, SQL Server databases, Unix, Unix Split Function

Find out what is in dbms_sql cursor
One option could be to write the statement to a file, using the UTL_FILE package, but it is possible that a similar limitation also exists in that package. I would use a loop to display the statement (using dbms_output) in 254 byte substrings. —————————

View Answer   |  February 25, 2009  11:26 PM
DBMS, DBMS_SQL, Dynamic SQL, Oracle

SQL Server 2000 error message involving ASP
Can you post the error that you are getting, and the T/SQL that you are executing? If the data is being updated the error probably isn’t coming from the SQL Server.

View Answer   |  February 25, 2009  11:06 PM
ASP, SQL Server 2000, SQL Server error messages, SQL Server errors

Shrinking a SQL Server database
Odds are your transaction log has filled the hard drive. Log into the instance with Query Analyzer and use the BACKUP LOG statement to remove the data from the transaction log. <pre>BACKUP LOG YourDatabase WITH TRUNCATE_ONLY</pre> You should then be able to shrink the log file using the DBCC SHRINKFILE statement. <pre>USE YourDatabase GO DBCC [...]

View Answer   |  February 25, 2009  9:18 PM
SQL Server 2000, SQL Server Database Shrinking, SQL Server databases, SQL Server Enterprise Manager

Send a email with attachment?
The blat utility is my friend. <a href=”http://windowsitpro.com/article/articleid/45886/blat-goes-the-message.html”>Windows ITPro reference</a>

View Answer   |  February 25, 2009  8:45 PM
SQL 2000, SQL scripts

Virtual machine setup – SQL 2005
Yes it is still advisable as this way the virtual machine’s OS will see the two disks separately and each will have its own IO queue. It also gives you more flexibility in the future if you move the VM to a larger host machine which has the drives laid out in multiple RAID 5 [...]

View Answer   |  February 25, 2009  6:57 PM
SQL, SQL 2005, Virtual Machines, VM

Backing up virtual SQL servers
I simply use the native backups (or LiteSpeed for larger databases) to backup to a network share on a NAS which is then replicated to a second newtork share each night.

View Answer   |  February 25, 2009  6:55 PM
ArcServe, SQL Server backup, SQL Server backup and restore, Virtual SQL Servers

CMPPFM, Space offset error.
CMPPFM is pretty resource intensive for big stuff. Why not read and compare the two file in a HLL? You can write an RPG pgm with program defined file lengths of “very big” and use OVRDBF at run time to point them at the files you want. If you make the records defined as either [...]

View Answer   |  February 25, 2009  2:39 PM
CMPPFM, SQL Exception, SQL/400

Taking a backup of a running site on a SQL Server
The<a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-backup-database-command/”> BACKUP DATABASE</a> statement will allow you to take backups of databases which are in use.

View Answer   |  February 25, 2009  1:01 AM
SQL Server backup, SQL Server backup and restore

The hierarchyid data type in SQL Server 2008
You should be able to add a new node is at the same level, them move all the children to be children of that parent.

View Answer   |  February 25, 2009  12:59 AM
Hierarchy data, SQL Server 2008, SQL Server Data Types

SQL Server user instance error
To enable that setting you would need to run a statement like this. <pre>exec sp_configure ‘user instances enabled’, 1 reconfigure</pre>

View Answer   |  February 25, 2009  12:58 AM
SQL Server errors, SQL Server User Instances