| Author |
Topic |
|
redbrad0
Posting Yak Master
176 Posts |
 Posted - 2002-03-20 : 01:24:07
|
 Edited by - redbrad0 on 03/21/2002 18:53:55 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-20 : 02:06:16
|
| Try This..EXEC sp_attach_single_file_db @dbname = 'backgroundplusnet', @physname = 'c:\mssql7\data\backgroundplusnet.mdf'HTH------------------If I am to do it,I will, and NOW .. |
 |
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2002-03-20 : 18:07:44
|
| Edited by - redbrad0 on 03/21/2002 18:54:22 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-20 : 18:40:57
|
| Drop the database you created, delete it's files, and retry the command above.-Chad |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2002-03-21 : 01:38:32
|
| Edited by - redbrad0 on 03/21/2002 18:54:43 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-21 : 02:04:23
|
| So there is no database by that name, and no file named backgroundplusnet_Log.LDF?You run sp_attach_single_file_db and you get 1813?If this is the case, There is one option to recover the database, but you will need to call Microsoft Support. They will assist you in recovering the DB.-Chad |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2002-03-21 : 02:45:26
|
| Edited by - redbrad0 on 03/21/2002 18:55:05 |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-21 : 04:12:10
|
| "well the problem is i dont have a "legal" copy of sql server"not a good idea (admitting or doing it)!...reversing the scenario....how would you like not to get paid for your work? despite a lot of misgivings about microsoft, work done needs to be paid for.in this case, your economy means that you have to resort to 'free' advice to sort out a problem that may have an real economic cost to you.shortcut's sometimes lead you through quicksand. |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2002-03-21 : 04:43:41
|
| Edited by - redbrad0 on 03/21/2002 18:53:32 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-21 : 07:52:23
|
| Not a problem... just send the guy's name and address to Chad and it will all get sorted out Damian |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-03-21 : 08:19:37
|
| Depends how far inland he is: I think Microsoft only own the navy so far. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-21 : 08:51:48
|
| "Depends how far inland he is: I think Microsoft only own the navy so far."Inland doesn't matter here...he seems to be drowning, so maybe the (MS) Navy would be his best bet. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-21 : 16:58:39
|
| Refer 'this guy' to the following organization:http://www.bsa.org/-Chad |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2002-03-21 : 18:50:16
|
well you can go ahead and report me, but I do not have any illegal copy of SQL Server. All my clients are hosted at a major hosting company that I sub things out to, so I have nothing to worry about, since I do not own any servers or any software that I have not purchased  |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-21 : 18:51:41
|
quote:
well you can go ahead and report me
Actually I think chad's suggestion was that you should report the other guy....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-21 : 19:10:12
|
quote:
All my clients are hosted at a major hosting company that I sub things out to, so I have nothing to worry about,
Unless your hosting co get shut down for illegal software use.Damian |
|
|
|
|
Creating database from MDF file.