UNSOLVED
Sql 2005 backup question
When I create a maintainance job to back up one DB that is on the AX150i, it just hangs.
The DB is 10GB the Logs 19GB.
I get these error messages:
Event Type: Error
Event Source: iScsiPrt
Event Category: None
Event ID: 20
Date: 9/7/2007
Time: 3:50:17 PM
User: N/A
Computer: DBCX0
Description:
Connection to the target was lost. The initiator will attempt to retry the connection.
Event Source: iScsiPrt
Event Category: None
Event ID: 20
Date: 9/7/2007
Time: 3:50:17 PM
User: N/A
Computer: DBCX0
Description:
Connection to the target was lost. The initiator will attempt to retry the connection.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The next event says it connected. It happens every minute until I kill the job. Can't connect, connected.
I'm running SQL 2005 connected using iscsi to the AX150i.
Both the NAS and the server are connected to the same switch.
Any info on how to get it backing up would be appreciated.
- I plugged the db server and the two connections from the SAN into a gigabit switch.The db is the only server attached to the 1.8 TB virtual. Still same errors. The db gets to about 10%and hangs. The database itself is 10GB, the log files are 19 GB.I'm going to move the database local and try backing up to the SAN.Thanks
softlover1
2 Posts
406
0
Posted August 19th, 2011 03:00
Hey,
Why bothered so much. TRY some SQL management software, they are much easier to use and much safer, because you can backup the data by schedule backup.
I always believe in Acronis and Paragon, they are the top leader in the field, that's why they are not cheap.
But some inexpensive software can also solve those problems nowaday, like EASEUS TODO BACKUP ADVANCED SERVER, they are easy to use and contain a lot of impressive featues.:-D
Hope I can help.
Dev Mgr
6 Operator
•
9308 Posts
•
3 Points
406
0
Posted September 10th, 2007 03:00
A few suggestions are:
- dedicate a nic or network (VLAN or dedicated Gbit switch) to iscsi
- put this is a different subnet than your regular networking.
- don't call the AX150i a NAS, as it's not and it will just create confusion when people try to understand your setup. This is a SAN. (check here and here to find some information that explains the difference)
- make sure you're not sharing virtual disks between systems unless they are clustered
A few questions:
- is the AX150i just your backup location?
- or do you have the database itself on there (or maybe both (in 2 different virtual disks))?
- if you have a dual processor unit, does the server (or do the servers if it's more than 1) have a link to both storage processors?