August 10, 2006 at 11:41 am
I am receiving this error when trying to re-attach a database.
I used the detach script : sp_detach_db @dbname ='db1'
I backed up the files to tape, then after that was done I tried to reattach the datafiles and get this error.
This is what I'm running and the error I get:
sp_attach_db @dbname ='db1',
@filenamel ='F:\mssql\data\db1\db1_01_data.MDF',
@filename2 ='F:\mssql\data\db1\db1_02_data.NDF',
@filename3 ='F:\mssql\data\db1\db1_03_data.NDF',
@filename4 ='F:\mssql\data\db1\db1_04_data.NDF',
@filename5 ='F:\mssql\data\db1\db1_05_data.NDF',
@filename6 ='F:\mssql\data\db1\db1_06_data.NDF',
@filename7 ='F:\mssql\data\db1\db1_07_data.NDF',
@filename8 ='F:\mssql\data\db1\db1_08_data.NDF',
@filename9 ='F:\mssql\data\db1\db1_09_data.NDF',
@filename10 ='F:\mssql\data\db1\db1_10_data.NDF',
@filename11 ='F:\mssql\data\db1\db1_11_data.NDF',
@filename12 ='F:\mssql\data\db1\db1_12_data.NDF',
@filename13 ='F:\mssql\data\db1\db1_log.ldf'
Server: Msg 8145, Level 16, State 2, Procedure sp_attach_db, Line 0
@filenamel is not a parameter for procedure sp_attach_db.
I am not moving these datafiles, they reside in the same spot I detached them from. It is SQL 2000. I've tried logging in as sa, as an administrator, running the script from a remote server, on the server itself. I tried restarting the SQL service. This has happened once before and mysteriously corrected itself- but now it won't!
Any ideas?- I'm really getting annoyed with the situation! Thanks...
August 10, 2006 at 11:51 am
@filenamel ='F:\mssql\data\db1\db1_01_data.MDF',
Look very carefully. The lowercase letter L is very similar to the number 1 ...
@filename1 ='F:\mssql\data\db1\db1_01_data.MDF',
August 10, 2006 at 12:10 pm
Uggh! Thanks. I had a feeling I was missing something dumb. You are absolutely right, the font I was using made it look alot like a one. And I didn't notice the difference after I pasted my query in the forum page.
Geesh..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply