So what happened when you used sp_attach_single_file_db? It's always worked for me.

SQL Server 2000

-SQLBill

I learned this in a MS Access class and a MS SQL Server course.

But it is an uncommon term for a row.  Just like 'attribute' is an uncommon term for...

Enterprise Manager is just a GUI. You can remove it without affecting the database(s) in any way. You can also reinstall it without affecting any DBs.  If you reinstall it,...

This sounds more like someone may have done it on purpose - they may not have intended those results.  As Azzam said, any optimisation would rollback if it failed.

-SQLBill

Can you not open Enterprise Manager or is that you can not open your database in Enterprise Manager?

If you can't find your database in EM, it's because you probably didn't...

Any folders have to already exist. The final file can be created by SQL Server during the backup, but the folder itself must be there BEFORE the backup begins.

-SQLBill

When you say it swelled to 20GB, do you mean that after restoring it to the TestDB you added more data?

If you restored the db to the test server and...

That's not completely true.....while TEMPDB is recreated everytime, it's settings are 'sticky'.  My settings for TEMPDB are different than my settings for MODEL, but everytime I reboot my server or...

RETAINDAYS is intended for TAPE backups. When backing up to disk, each backup needs to go to a different file. For example, each backup file could be saved with it's...

It sounds like:

1. you really don't have permission to change the settings or

2. you have an application that is changing the settings.

-SQLBill

The -E option requires that your SQL Server login be:

1. the same as your Windows account

and

2. set to Windows Authentication.

Things to check

1. do you have a login on SQL Server

2. is...

Quote:

i think i shld have a backup in future.

I think you should have a backup NOW!

-SQLBill

Have you ever backed up to E before?

Is it a local drive or a network drive?

Is it a CD drive?

SQL Server doesn't like backing up to network drives.

-SQLBill

As I remember it, you can not remove BUILTIN/Administrators login when you are using clustering.

-SQLBill

If you use SIMPLE mode, you can't backup the log file. If you can't back it up, you can't restore it. So truncating doesn't matter.

If you use FULL (Or Bulk-logged)...