I found yet another place where the TCPIP can be adjusted. Remember how you can go to the SQL Server Configuration Manager, and enable the TCPIP under the SQL Native Client Configuration?? […]
create a backup job for every database. these are native backups to e:\backup\ drive, using a .txt ouput file to d:\backupreport create a backup job for every database (using cursors of course) […]
i get amazed some times with how long one can be doing sql administraiton, and yet still get blindsided by the strange and unusual. i get this error message one day just […]
Search Terms: DBCC SHRINKFILE not working. Here is the solution. DBCC SHRINKFILE doesn’t work. Here is the solution.
using sp_msforeachdb: sp_msforeachdb ‘BACKUP DATABASE ? TO DISK = ”\\MyShare\Backup\?.bak” WITH FORMAT’ here’s another one. even though these kinds of scripts aren’t difficult to produce i figure why not post it any […]
we’ll be working with the following to correct this handshake issue. SQL Server Configuration Manager: Start – Programs – SQL Server 2005 – SQL Server Configuration Manager go to ‘SQL Server 2005 […]
use master go set nocount on select ‘exec master.dbo.xp_backup_database @database = ”’ + name + ”’, @filename = ”D:\MyPath\’ + name + ‘ LiteSpeed_Full.BKP”, @init = 1, @logging = 0, @with = […]