http://www.aspfree.com/c/a/VB.NET/Simple-BackupRestore-Utility-With-SQLDMO-Using-VBNET/

http://www.codeproject.com/vb/net/SQLDBBackup.asp

My bad I forgot to mention that... you will find this utility in SQL 2000 UPGRADE folder but works with 2005...

If you have any 2000 server check the UPGRADE folder...I...

Some times it may take many hours...

If you have LOB in your db... it may not shrink at all...see the following article...

DBCC SHRINKFILE and SHRINKDATABASE commands may not work because...

I didn't quite understand what you are trying to says..."Due to an error, I had a database which originally was created in the master database."...

CREATE PROCEDURE VerifyIfInvoiceExists

(@Invoice VARCHAR(50))

AS

IF EXISTS (SELECT 1 FROM IPN_received WHERE invoice = @Invoice)

RETURN 1

ELSE

RETURN 0

Yes, sql login passwords are case sensitive in 2005 ... MS uses the WINDOW security API for sql server for security...

http://www.microsoft.com/sql/technologies/security/security-at-a-glance.mspx

http://msdn.microsoft.com/msdnmag/issues/05/06/sqlserversecurity/default.aspx

copy the file scptxfr.exe file from C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade folder and use this utility to script the objects and it works with sql 2005.

also to script logins you can...

Does SQL agent has the access to this network folder?

Why don't you save the dtsx file locally on the server?

Change your MAX CHARACTER PER COLUMN setting to 8192 and change our result set to GRID MODE...

SQL will not display > 8000 characters per column....

It is gracefully file closed...

Try CREATE DATABASE with ATTACH_REBUILD_LOG option ...

See BOL for syntax..

http://msdn2.microsoft.com/en-us/library/ms176061.aspx

This could be bug in SP2 CTP

Post in Microsoft Forum...

No.

You can try if there are any third party tools to crack...

Looks like you are passing db name instead of file name to shrink command..

You can make use of the code from the following...

http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp

If you have the space in the network where you can reach by using UNC name then

use trace flag 1807 then

restore the db using the UNC path then...

I never saw this... but is this backup taken to server or disk OR CD/DVD?...

Try to backup WITH INIT option again... and then try again...restore...