Downloand 7-Zip command line utility from the below link and make use of it. The utility is totally free and im using in my environment.

http://downloads.sourceforge.net/sevenzip/7za442.zip

Im my view changing the recovery model and taking tran log backup is merely unnecessary one.

As you know we are not going to change \ do frequent transactions in master...

Before restore:

Use Restore verifyonly to make sure you have valid backup for restoration

Ensure no connections to be exists in the database

Make sure you have necessary space to restore the database

After...

Refer the below link

Moving sys db's

You can do the following

Backup the database from source server (backup size is 320 GB)

Copy the backup file from source to destination server. You can use xcopy or robocopy to...

Refer the below links, this may help you.

How to avoid using shrink in SQL Server 2005?

Here's a good reason not to run SHRINKDATABASE

Why you want to be restrictive with shrink...

[font="Courier New"]My advice is not to go for SQL server 2005, its better to go for SQL server 2008 which will be released coming Feb 2008. Microsoft has announced that...

In the shrink window, you can shrink only to the freespace percent shown. You can't go beyond the limit specified hence the commited datas to the mdf file wont be...

[font="Courier New"]Check whether any process is running on the db at the time of the DTS is running. The samething has happend to us and we found DBCC is running...

[font="Comic Sans MS"]For Randy:

Kindly check the path where you are storing the perform results eg. "C:\perfmon\test.csv" and make sure the path exists and you have the right permission on the...

[font="Comic Sans MS"]Try use different connection manager for delete purpose

Are you running the package as a job or from BIDS?

In the connection manager have you specified correct username and password...

You cann't update System tables in SQL server 2005

You can connect to the named instance as

servername\instancename,portnumber

Default the TCP\IP port number is 1433

Try disabling the Email Operator itself instead of disabling in each job.

Expand SQL server agent

Expand Oprator

Right click on the email operator and uncheck the enabled check box

click ok

When you schedule a SSIS package and when it runs as scheduled job , if windows authentication is used inside the package then it will sure take sql server agent...