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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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