In SQL 2000 easily I could make a remote backup by changing destination from local storage to network shared folder “\\192.168.1.1\share or \\192.168.1.1\d$\backups” but in 2008 it is not possible to If you are getting error 53 then make sure the share is created properly. You cannot post IFCode. You cannot post EmotIcons. check over here
Join Now Dear All, I am using SQL Server 2012 and I am setting up a Meintenance Plan for backup. Any ideas? Reason: 1815).
I think the db had a different owner, different from the one logged in and that was the issue.Thara Post #778066 « Prev Topic | Next Topic » 11 posts,Page 1 Even if i type in the path and filename it doesnt accept. All Rights Reserved. Under the sql logs, I found the following error message: BackupDiskFile:: CreateMedia: Backup device "\\remote_drive\folder\db_backup....bak" failed to create.
Either the location odes not exist, or the current login account does not have access to it. You cannot post HTML code. In SQL 2000 easily I could make a remote backup by changing destination from local storage to network shared folder “\\192.168.1.1\share or \\192.168.1.1\d$\backups” but in 2008 it is not possible to http://ycsoftware.net/the-database-engine-service-could-not-resolve-the-specified-location/ Database Engine service could not resolve the specified file location By Deep Posted On Monday, October 11, 2010 // 4 comments Have you encountered this error message while trying to back
it my knowledge the backup size of database is near to mdf file size of database.so please guide it is correct or wrong tkizer Almighty SQL Goddess USA 38200 Posts Posted-10/20/2010: It's listed under configuration tools in the SQL Server programs list. Which user/role comes into play. About Me Nicholas Bisciotti View my complete profile Logos Labels SharePoint (127) SharePoint 3.0 (94) Support (60) Links (48) SharePoint 2013 (31) SharePoint 4.0 (31) Events (27) SQL Server (25) Search
If you get stuck you can get support by emailing [email protected] If this is your first visit, be sure to check out the FAQ by clicking the link above. http://www.sqlservercentral.com/Forums/Topic466539-173-1.aspx My Blog Reply bbcompent1 All-Star 33974 Points 9512 Posts Moderator Re: Backup maintenance plan not working on remote drive Nov 29, 2011 09:55 AM|bbcompent1|LINK Try looking on the remote system's event I have already created a backup using SQL server management studio, and have saved the backup to the following loction: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ystm.bak However, when trying to select this location If you look in the event viewer, it will show you the network ID that is trying to write into that folder.
Mark as answer posts that helped you. check my blog OK, OK... I looked under SQL Server logs but they have a similar message as the event viewer. Mark as answer posts that helped you.
Verify that the folder exists, and that the login account has permissions on it. ------------------------------ BUTTONS: OK ------------------------------ user is domain administrator thanks Sunday, January 05, 2014 12:39 PM Reply | If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? I repeat that nothing has changed on the source server. http://deftmag.com/the-database/the-database-engine-could-not-lock-table-relationships.html For your interest, I created another maintenance plan using the Maintenance Wizard.
How do i change these settings? My Blog Reply bbcompent1 All-Star 33974 Points 9512 Posts Moderator Re: Backup maintenance plan not working on remote drive Nov 28, 2011 11:13 AM|bbcompent1|LINK You'll probably want to give Network Service That will use the same account as the restore.
Sorry for my ignorance but the Network Service permission is on the destination server/drive - right? Can anyone help?TIA Together, we can make wonders! This is not likely to be an issue with the SQL Server version, but a fact that your new SQL Server machine is configured differently. (And since the error code indicates Doh!..
You cannot delete your own posts. Post #527029 thara.jacobthara.jacob Posted Wednesday, August 26, 2009 10:36 PM Forum Newbie Group: General Forum Members Last Login: Thursday, August 27, 2009 1:58 AM Points: 2, Visits: 4 Hi All,I have The concept is calledleast privileged account where you only want to give a particular process a certain level of permission and then increase it as needed. http://deftmag.com/the-database/the-database-engine-could-not-access-the-file-called-edb-log.html Mark as answer posts that helped you.
If your network protocols are enabled liek TCP/IP then check Go to control panel -> services OR open run command and type services.msc This brings you list of all the services
© Copyright 2017 deftmag.com. All rights reserved.