SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Sql server 2012 can't find .bak file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Psycho187
Starting Member

South Africa
4 Posts

Posted - 08/22/2013 :  09:24:59  Show Profile  Reply with Quote
hi There,

i've been searching and searching for days now for a solution to my problem and i haven't come across anyone that can help me. i've just installed sql server 2012 on a virtual server 2012 and i'm trying to restore a .bak file on sql, but when i try and find the file, it shows me that there's no file there, any help would be greatly appreciated.

many thanks

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 08/22/2013 :  09:40:01  Show Profile  Reply with Quote
quote:
Originally posted by Psycho187

hi There,

i've been searching and searching for days now for a solution to my problem and i haven't come across anyone that can help me. i've just installed sql server 2012 on a virtual server 2012 and i'm trying to restore a .bak file on sql, but when i try and find the file, it shows me that there's no file there, any help would be greatly appreciated.

many thanks

Do you mean that you are trying to restore a database backup to the new server? Are you able to see the backup file on the file system using Windows Explorer?
Go to Top of Page

Psycho187
Starting Member

South Africa
4 Posts

Posted - 08/22/2013 :  09:50:04  Show Profile  Reply with Quote
yes, i'm trying to restore a database backup file from sql server 2008 on to sql server 2012, i have successfully done the same thing on my windows 8 machine and it found it and restored it with no problems, after i install sql 2012 on windows server 2012 i suddenly can't see the back file in the location that i put it in with sql 2012. yes i'm able to see the backup file with windows explorer.

Edited by - Psycho187 on 08/22/2013 09:50:54
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1642 Posts

Posted - 08/22/2013 :  19:15:53  Show Profile  Reply with Quote
Is there a different service account being used by the SQL 2012 service? Perhaps it doesn't have access to the directory where the backups are held.

=================================================
The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen
Go to Top of Page

Psycho187
Starting Member

South Africa
4 Posts

Posted - 08/26/2013 :  02:06:36  Show Profile  Reply with Quote
@Bustaz - please explain, i don't understand. i've only got 2 service accounts, 1 for sql 2005 even though i don't have that on my pc and 1 other service account for sql. Ho do i set the service accounts to have access to the folder i have my backups in?
Go to Top of Page

Psycho187
Starting Member

South Africa
4 Posts

Posted - 08/26/2013 :  05:55:53  Show Profile  Reply with Quote
i just found a user account called "service" in the user accounts in the security tab on the folder, once i included that account in the list of users, i then restarted sql server, just to make sure, and then i was able to see my sql back up files, i don't know why i took this long to solve such a little problem. thank you for all the replies.

Edited by - Psycho187 on 08/26/2013 06:00:54
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 05/06/2014 :  02:01:31  Show Profile  Reply with Quote
u should first specify a path for .bak file at the time of restoration. If problem persists further then use online available backup recovery utilities.
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1642 Posts

Posted - 05/09/2014 :  16:31:40  Show Profile  Reply with Quote
The SQL Server service account can be found by Start->Control Panel->Administrative Tools->Services. Double-click on the SQL Server service->Log On tab. You'll either be using the "Local System account" or "This account" to define a specific account. If you are using the Local System account, you won't be able to reference backups that are not local to the server. If, instead, you have defined the account to use, this is the account that needs to have access to the backup file location. Your ability to access the backups using your personal logon is irrelevant; it is the SQL Server account that is used, even though you are initiating the backup. Your IT people should be able to determine what rights are granted to each account.

===============================================================================
“Opportunity is missed by most people because it is dressed in overalls and looks like work.” - T.A.Edison
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000