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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-02-03 : 13:06:17
|
| how do I backup a mssql express db?I can't get into the management tool so i'm thinking of reinstalling -- is the db saved on any file on the computer that I can backup? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-03 : 19:04:06
|
you can do it in t-sql using backup command
KH |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-04 : 01:06:48
|
| is there anyway to run tsql without the management tool which I can't get into |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-04 : 02:18:42
|
Query Analyser ?
KH |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-04 : 02:26:14
|
| this is in sql server express and I can't get into the managment studio so thought reinstalling may help but I need to backup first. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-04 : 02:51:47
|
| i guess none of this will work if I can't get into the db. it's very strange -- i get an error that named pipe remote connections are not allowed (even locally) when it is set up for remote connections |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-02-05 : 06:50:14
|
| I'm not very familiar with 2005 in any variant but can't you disable named pipes and perhaps use IP instead to connect? Or at least ensure that named pipes aren't the default protocolsteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
|
|
backup db