Yes,

check the maint plan task backing up, it sometimes has a "verify back up on completion" checked on,

which might increase the time after the actual backup..

It also depends on the...

ALZDBA (5/31/2011)

---

also to keep in mind: you can "restart" a restore !

restore database ...

with

, RESTART

I recall using this a couple of time on win2003 os with sql2005sp2 with...

on google i found abt IRPStack and changign registry, i...

Windows logs :--

BackupMedium::ReportIoError: read failure on backup device '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'. Operating system error 1130(Not enough server storage is available to process...

Ninja's_RGR'us (5/31/2011)

---

SKYBVI (5/31/2011)

---

@ all

thanks guyz,

I again tried restoring thru query...

and this time it got restored...it took 7 hrs to retore 300gb db...

its too much time i guess....but then...

@ all

thanks guyz,

I again tried restoring thru query...

and this time it got restored...it took 7 hrs to retore 300gb db...

its too much time i guess....but then all's well...

When iam restoring via this query :-

RESTORE DATABASE RTW

FROM DISK = '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'

WITH MOVE 'GPSRTWDat.mdf' TO 'E:\MSSQL\Data\RTW.mdf',

MOVE 'GPSRTWLog.ldf' TO 'E:\MSSQL\Data\RTW.ldf',

STATS=5

It does 30% and then throws this ERROR:--

30 percent processed.

Msg 3203, Level...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615

Perry Whittle (5/30/2011)

---

at a wild guess i would say the original disk locations do not exist on the new server.

Does the new server have the same drive letters and paths?

If...

Ninja's_RGR'us (5/30/2011)

---

Take a backup of a small and try restoring it to the same driver / folder that is giving you the error.

That may also give you an opportunity to...

not much on the server as its newly build ...it has

Microsoft dynamics Great Plains

SQL server 2005

Acronis true image server and

symantec endpoint protection

Yes, im connected to right server for restoration.

How...

Its nt tht big..

mdf file 310 gb

log file 1 gb

.bak file 150 gb

Space is not an issue because i tried on diff drive also ( drive...

and the bak file is just 150 gb

Regards,

Sushant

I click on .dtsx file and copy

but when i open another package

i cant paste tht .dtsx file here.

Regards,

Sushant

When u post a reply,

see bottom of page, there is option edit attachments, click that,

upload file and attach..

If u have problem in getting,

send to syadav@rtwbvi.com

Regards,

Sushant