Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tks
Starting Member
48 Posts |
 Posted - 2005-12-13 : 16:24:48
|
| HI all,my first post, is to discuss if i have found an bug or if its just me doing something wrong.From VB i execute using ado the following statement:backup Database Database name to Disk = 'C:\Test.bak'when database is an normal database name it works fine!But when database is an database with an space in its namethe ado component says that there is an error near TO...Any one ideas?Another one:I also use the Microsoft Tools wich come with the SQL server editions..when i restore an db (from an db on the server) to a new name (non created database) it first says that it cant do that, then when i click overwrite... and UNDO it again...it lets me restore but i have no idea if it then overwrites or not..(the V is still unchecked)..Hope to hear...Tks |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-12-13 : 16:28:02
|
| Chuck a pair of square brackets around the name...ie backup database [my poorly named database] etc...HINT.. Don't use spaces for any object name in a database.. or in any programming language in general...DavidMIntelligent Design is NOT science.A front-end is something that tries to violate a back-end. |
 |
|
|
Tks
Starting Member
48 Posts |
Posted - 2005-12-13 : 16:30:41
|
| Yes sir!It worked!Its just that i new it worked normally without! and i was guessing wy it didn't with an space..i tryed other common chars but ok..Tks |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-14 : 00:20:08
|
| Instead of space use underscore(_) to avoid this kind of difficultiesMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Think i found an bug