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 |
|
mdean9999
Starting Member
21 Posts |
 Posted - 2011-05-15 : 10:34:35
|
| I can backup smaller databases on to my local machine.I have one database which fails. In this case 14 of the 20 tables are copied from online to my local 2008 server.I then get a message 'this job failed - check the event log on the destination server for details'.First question please, where is this event log so I can see what it has failed on. Possibly just timed out?What might I be doing wrong please? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-15 : 10:57:37
|
| Usually you can access event viewer from Computer Management in the control panel, or start->run->compmgmt.msc.The best place to start probably is the information in the event log. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-15 : 12:10:00
|
| What exactly do you mean by 'backup'? I ask, because SQL backups don't work table-by-table.--Gail ShawSQL Server MVP |
|
|
|
stipen4
Starting Member
3 Posts |
Posted - 2011-05-17 : 07:44:52
|
| Hi friendServers are often dedicated, meaning that they perform no other tasks besides their server tasks. On multiprocessing operating systems, however, a single computer can execute several programs at once. A server in this case could refer to the program that is managing resources rather than the entire computer.unspammedstipen4 |
|
|
|
|
|
|
sql server 2008 backups