Hi Venu,

The database backup fails mainly due to disk space issue. You must ensure that you must have almost 3 times of free disk space compare to size of your...

This depends the timestamp of the backup file. In your cases, the 3 days old files are not old enough ( say 2 days, 59 minutes, 55 sec ) to...

Hi Venu,

There are ways to check the location of log files.

From SQL Server Mgmt Studio, you go to Management --> SQL Server Logs --> Current Logs. You can see the...

Hi Venu,

Each Maintenance Plan creates Jobs with respect to the activities you specify in the plan definition.

If you have properly created the Maintenance Plan for db backup, a associated job...

I agree with Krishna view. The backup strategy depends on the business need and kind of cost and risk the business is ready to take.

Still taking a Full Backup everytime...

There is no such limit for compressed folder. The backup might be failing due to no response from the disk for sometime.

There may not be much issue on the backup. If you have enough disk space then no problem.

You might face a bit of slow responce while the backup is going...

You need to check for Indentity column. You need to see if the values are Identical in source table then ignore the field/column export to destination server. Identity column will...

You can try something like this. Restore your latest Full Backup file with a new database name using the NO RECOVERY option. After this the database should status will show...

Based on my experience, this error is related to OS and Network issue. It has nothing to do with SQL Server.

If the OS is not able to determine the...

Hi Rubina,

Normally this will not cuase any problem. There is no data integrity issue due to Replication and Backup activity happening together at one time. The risk is only for...

Hello,

Alot of search and did not seen the workaround. All you need to do is create a new database with the same name as the one that you want...

Please check this for detailed

http://www.microsoft.com/sqlserver/2005/en/us/integration-services.aspx

Hi Chirag,

Correct. The data file growth will be lower in most of the cases. This is what most of friends are saying above. Enjoy.

This may be correct and may not be. The Transaction long records all the activities which are performed on the database. Most of the time, the size of transaction log...