I wish I had some answers and I am experiencing these same type issues. For the life of me I don't know why such a simple thing is so difficult....

I tried that.... it isn't there... I even went thought and created another one and it did not show up... I am stumped.

 In 8 years our youngest will graduate from High School. We have talked about a year or so after that of moving to Charlotte or some warm city in the south and...

I figured out my problem. The -s is case sensitive and needs to be capitalized..

sqlcmd –E  –S servername\INST3 –Q”restore database master from disk = ‘E:\backup\INST3\master_backup_200701021308.bak’”

I use this script.

SET NOCOUNT ON

SELECT 'EXEC sp_addlogin @loginame = ''' + loginname + ''''

,', @defdb = ''' + dbname + ''''

,', @deflanguage = ''' + language + ''''

,', @encryptopt...

Select the db, goto Report, disk usage. On that report Disk space used by tables... it will show space used by indexes in there.

In 2000 you could have a one letter word or even a blank password. In SQL 2005 i don't think you can.... if you want to transfer you will have...

Depends. Detach / attach works and backup/restore works fine. In my workings I have typically gone with backup restore when I have moved from SQL 7 to 2000 or simply...

You can't perfom online indexing when the table contains LOB data like TEXT, NTEXT, IMAGE...

this is true in Oracle as well I believe.

 You should get an error stating it is not a microsoft backup file or something to that effect.

Have you tried these options ???  Try either or both. You will be able to tell if SQL Server can read the backups at least. If it cannot read them...

In our shop we have DB2 MVS, AIX, NT, Oracle on Windows, Linux, AIX and SQL Server. All of our Store support stuff is on Oracle and it is very,...

Here the way it is done is there is a development team and a support team. After a new app is developed and in production for a month it is...

 Interesting. Thanks. When I first installed my first SQL2005 before SP1 came out I thought this worked... but don't remember for sure.

You must create another task of Maintance cleanup task and then specify the folders of which you have the db backups to delete from. Also, be careful of the file...