MSSQLTips

Hi My name Kasi viswanadh. I have one query to you i.e. Let me explain site setup. we have one fax server application for that we install SQL express. In sql express dosnt cosist SQL-AGENT service. Can any one guide us what is backup and restore script for sql express and need to place in batch file...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

I have Ms SQLserver 2005 running on windows server 2003 std edition. Help me out taking backup from the server to desktopPC which has windows XP serverpack 2 as an operating system.

donot have even tranaction log backup. if you have transaction log backup then we can recover by apply trans backup to old DB.

By mistake I restore the old database backup on the database and i don't have any latest backup. Is there any way i can rollbacl that restore...

UPDATE: This script requires the Invoke-TryCatch.ps1 and the newly posted Invoke-Nz.ps1 scripts as well - thanks to all who pinged me about the Inovke-Nz.ps1 being required. A while back I posted on Automating a Database Restore and it was quite a popular post, I also received multiple emails with requests...

deal11deal1, Check out this tip: http://www.mssqltips.com/tip.asp?tip=1584 Thank you, The MSSQLTips Team

NOTE: See an updated version of this functionality using Powershell and supporting some additional functionality here . It's quite common to see automated/custom procedures for backing up a database/log - nearly everywhere I go companies have custom backup procedures and processes to handle backups...

This post will cover an initial overview of the data compression feature that will be included in Sql Server 2008, and I'll also cover briefly some information on the Backup Compression feature as well (note that these are 2 totally separate and distinct features, since they are very different, as...

So, here's an interesting scenario I ran into a few weeks back. A customer had a situation in which they were using a read-only database (to serve reports/ad-hoc queries during production hours) that was loaded nightly with differential data from a variety of systems. This data was imported to the...