UltraBac Software  

Go Back   UltraBac Software Forum > UltraBac Technical Support > SQL Agent
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2014, 02:37 PM
dvillegas dvillegas is offline
Member
 
Join Date: Aug 2011
Location: México
Posts: 46
Question Error Restored SQL

Hello

I have a problem to restore SQL databases, when restoring modifying their attributes, all you see is that you restore a tmp file and not the file mdf and ldf database, because it is given?

Now on the other hand performed the direct restorative procedure and did not send me any errors but neither hits.

Attached the log


RESTORE LOG - UltraBac 9.2.5 - Build Date: 2012-07-26.
RESTORE started On: 3/19/2014 4:30:17 PM

Description: SQL Agent
User: DSMEXICO\administrator
Agent: SQL
Agent Host: SERVERDS
Password Protected: false
Computer Name: SERVERDS (Windows 6.1.7600)
Log Type: Summary.


Device: BackupPath1 (SQL (\\192.168.1.202\Backups\UltraBac\SERVERDS\SQL\))

Restore options summary:
Alt Database Name: restored

Restored SERVERDS\UBTE8D7.tmp to SERVERDS\UBTE8D7.tmp successfully.
Restored SERVERDS\UBTA350.tmp to SERVERDS\UBTA350.tmp successfully.

-----------------------------------------------------------------------------

RESTORE SUMMARY:
Begin: 3/19/2014 4:30:17 PM
End: 3/19/2014 4:33:32 PM
Duration: 00:03:14 Rate: (34.65 MB/Sec 2.03 GB/Min 121.82 GB/Hour)
Media Capacity: 2773.134 GB.
Media Remaining: 2297.887 GB.
0 Errors and 0 Warnings
1 Files Completed/1 Files Selected
1 Folders Completed/1 Folders Selected
7,049,054,032 Bytes Completed/7,049,054,032 Bytes Selected.






END OF LOG
Attached Images
File Type: jpg Captura1.jpg (14.4 KB, 2 views)

Last edited by dvillegas : 04-01-2014 at 03:27 PM.
Reply With Quote
  #2  
Old 04-24-2014, 02:05 PM
James Dawes James Dawes is offline
UltraBac Technical Support Manager
 
Join Date: Mar 2007
Posts: 129
Default

Hello Dvillegas,
Please see: UltraBac Knowledge Base - SQL Agent for restoring a SQL database to an alternate location and/or with a new database name.
__________________
James Dawes
UltraBac Software
Technical Support Manager
James@ultrabac.com
425-644-6000
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 10:54 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © 2001-2015 UltraBac Software