You may also read this article for more information on scripting the Backup and Restore.

http://www.mssqltips.com/tip.asp?tip=1584

Regards, Atul

Hi,

You can sample scripts from many places. But to run them at specific time, you need to create the Job and run the script within the job itself. Once the...

The tool is designed in the way that it should meet the requirement of all sort of requests. Let it be disk backup, tape backup, file backup, file group backup,...

You can simply backup the databases without using all the options in your script. You need not to use all the options available for backup script.

As long as your...

You can simply backup the databases without using all the options in your script. You need not to use all the options available for backup script.

As long as your...

Did you try to access the destination folder after password change ?

\\server1011\HLFHB_01025\ The accessibility should be checked in this case with write permission.

Here is the script that will allow you to backup each database within your instance of SQL Server. You will need to change the @path to the appropriate backup...

Good query by Jeffery. Yes it will work untill the msdb is not restored post user database restoration.

You can try this code in the test environment. If this works fine in your case the use it.

DECLARE @DeleteFiles NVARCHAR(4000)

DECLARE file_cursor CURSOR FOR

SELECT 'exec xp_cmdshell ''DEL "'

...

Hi,

You need to check your database recovery mode in Properties window. It should be Full Recovery for best result.

You also need to check the frequescy of database Full Backup and...

The snapshot holds locks during the snapshot generation processs. This is what you are seeing.

You need to investigate why these deadlocks are occuring and see if you can change the...

The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in...

But even restoring the 42GB file should not take more then one hour. I things something else is going on the server or the disk is not having more than...

This may provide some light on the usage of DBCC Updateusage and SP_updatestats.

DBCC UPDATEUSAGE corrects the rows, used, reserved, and dpages columns of the sysindexes table for tables and clustered...

Microsoft has released couple of hot fixes. But as I said I have not heard or read the problem related to yours. I tried the same on my servers and...