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 |
|
darius_sutherland
Starting Member
17 Posts |
 Posted - 2008-10-14 : 04:17:52
|
| Hi.Can't seem to backup any database even very small ones on a names instance of SQL 2005. 1 Default Instance & 2 Named Instances on Server.No Idea Why. Logs Don't really tell me anything at all, just Syntax Error Line one is all I can see so far. It's setup as I would normally set it up in Maintenance plan and works for other servers.Might try a manual SP back up.Thanx in advance...Dwww.state-of-mind.co.uk | www.photographersinbrighton.org.uk | www.sussexweddingphotographers.org.uk |
|
|
darius_sutherland
Starting Member
17 Posts |
Posted - 2008-10-14 : 05:55:09
|
| Well. If I run the backups off the default instance all works fine. Sureley there still is some problem with the above tho...DState Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 08:37:08
|
| what error do you get? |
|
|
|
darius_sutherland
Starting Member
17 Posts |
Posted - 2008-10-14 : 10:34:40
|
| Can't actually see the error.From all the logs I can find, it just says either nothing / no log or Syntax Error Line 1State Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-08 : 15:25:33
|
| *Edit: Removed as post is 2 years old.* |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-08 : 15:28:14
|
| Yeah, I just noticed....--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Named Instance Backup Fails