DBCreator Not Able To Locate Backup File
Feb 21, 2008
Hi
According to BOL, dbcreator should able to create, restore, backup, and etc.
But when i tried to restore with dbcreator's server role, it displayed this error message
TITLE: Locate Backup File - XXXX
------------------------------
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
May I know what i had missed out?
Thanks In advance
View 8 Replies
ADVERTISEMENT
Nov 12, 2007
Hi All,
I am truncating Transactionlog€¦ following the steps mentioned in MSKB.. what is the problem?
Use master
Go
Backup log xxx with truncate_only
go
Dbcc shrinkfile(xxx_Log)
Go
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'xxx_Log' for database 'master' in sys.database_files.
The file either does not exist, or was dropped.
Please help me.
Thanks in advance
View 31 Replies
View Related
Jul 11, 2007
Using SQL Server 2005 Server Management Studio, I attempted to back up a database, and received this error:
Backup failed: System.Data.SqlClient.SqlError: Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the satement after the current backup or file manipulation is completed (Microsoft.SqlServer.Smo)
Program location:
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)
Backup Options were set to:
Back up to the existing media set
Overwrite all existing backup sets
I am fairly new to SQL 2005. Can someone help me get past this issue? What other information do I need to provide?
View 11 Replies
View Related
Dec 5, 2006
What is the difference between "Files aned File Groups" backup and Partial Backup?
Looks like both are same.. Please comment.
View 3 Replies
View Related
Sep 8, 2015
I got full backup on daily schedule its taking more space on Drive because each file has more than 25GB.I am using SLQ server 2008R2 so I'm looking to take the backup with compression instead of uncompressed Backup. What are the impacts of compressed backup. Is there any problems with compressed backup while restoring the backup file.
View 8 Replies
View Related
Apr 1, 2008
I should restore a SQL Server 2005 Database from backup. The backup contains three files, named user.bak0, user.bak1 and user.bak2.
How is the syntax of the restore filelistonly and the restore database ... ?
I usualy write
restore filelistonly from disk = 'path and filenam.bak'
restore database. zy
from disk = 'path and filename.bak'
with replace,
move.....
move....
This works but I cannot use it with a splitted backup file. The files are much too big to put together to one file.
Thanks in advance for any help.
View 3 Replies
View Related
Jun 11, 2015
My customer got a total hard drive failure.After sending it to drive recovery specialist we were able to recover the LDF log file (MyDB_0.LDF).But the MDF file was completely destroyed (MyDB.MDF).They have a good full backup from a month ago.
1) Installed SQL Server 2012 on a new PC
2) Created a new database of same name (MyDB) - with same MDF and LDF file names as original
3) Took the new database offline
4) deleted the MDF and LDF files of the new database
5) put "MyDB_0.LDF" in the place of the LDF file I just deletedÂ
6) put the database back on-line
7) after hitting F5 to refresh databases - it shows "MyDB (Recovery Pending)"
8) tried to do Tail Log Backup with this command
  BACKUP LOG [MyDB] TO DISK = N'C:BACKUPMyDB_TailLog.bak'
WITH NO_TRUNCATE
And I get this error...
Msg 3447, Level 16, State 1, Line 3
Could not activate or scan all of the log files for database 'MyDB'.
The sad thing is I know we can get this data back using ApexSQL-Log. I can see all the transactions since the last full backup in this program - so the log file is not damaged. But my client doesn't want to pay the $2000 fee for this software.There has to be a way to restore this data, without having to purchase a third party tool.
View 13 Replies
View Related
May 8, 2015
I checked quickly one network  and I ran into the folders; I found out the folder MSSQL backup, nothing strange so far. Within that folder, anyway, I found out several backup and one very huge file (datawarehouse) with extension FILE. I am wondering what can be? I got datawarehouse mdf of course and datawarehouse log but what is that huge file (1 TB)?
View 6 Replies
View Related
Aug 21, 2014
I have just loaded some tables to our main db.there is a col in one table called MAPCONCEPTID.I want to know how to find where MAPCONCEPTID field in one of the table is mapped to.
View 3 Replies
View Related
Nov 13, 2007
Hi,
Can someone help me, I installed SQL 2005 Enterpirse Editon on windows clustered servers. Then after the installation
I want to change the path of my DB logs but the problem was, I can not see the other drives. I can see only the drive where the DB was located. Is there any special configurations that should be done.
Thanks.
Russell
View 1 Replies
View Related
Dec 14, 1999
How can I get my hands on the Microsoft SQL Server resource kit?
In particular, I need the "Load Simulator" application.
Any information would be greatly appreciated.
Jim
View 1 Replies
View Related
Feb 27, 2006
I am creating a table on the fly and then trying to associated the table
inside of a cube, using vbs script. For some reason I get a table not found
error when I try and open the cube, but when I look at the SQL server I am
able to see the table and I can insert the table via analysis manager, but I
get Unable to retrieve the list of columns for the <table name> table.
Any Ideas why I am not able to add the table from the analyzer?
View 10 Replies
View Related
Feb 7, 2004
Hey there, could someone please help me!!
I had created a database in sql server but since then installed windows xp pro and now when i go through the microsoft sql server dsn configuration the database is not valid and therefore i cannot change the default database as it says it doesn't exist.
So then when i type in command prompt use 'db' it says it doesn't exist but when i try to create 'db' it says that the database already exists.
I get the error message, could not locate entry in sysdatabases for 'cti' (database name).
When i look in mysql - data - along with master etc there is my cti.mdf and log files??
I'm stuck???
Is it that the files just aren't registering through sql server???
Please help!
View 2 Replies
View Related
Sep 22, 2014
Is there a query that I can run in SQL to find all the table names? I have a certain table I am trying to locate.
View 1 Replies
View Related
Sep 18, 2005
I have created a new filegroup,and i want to add existing table to the file group.
I don't have the appropriate syntax for this.
Please Help.
Regards Mr. Mumin
Thanks All,
View 1 Replies
View Related
Aug 2, 2006
I have a sql table containing names of departments. Is there a way after a user has typed a department in a textbox on a web page I can search for it in the sql table and if it isn't there then add it. I am using asp.net for the web page.
View 3 Replies
View Related
Sep 1, 2006
when we get something like this in QA:
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ','.
I only have 3 lines inclusing only one insert. How do I know what value or keyword is wrong from the error message above.
Thanks
View 4 Replies
View Related
Feb 5, 2008
Hi,
I am trying to locate my SSRS log files to troubleshoot some report problems.
I run Microsoft Visual Studio when designing reports using Report Designer, from a local installation of MSSQL Developer Edition on my notebook. The data source I work on is on a remote SQL Server.
I expect to find the SSRS Log Files on my local installation but I am having trouble locating it.
Please help.
Thanks in advance.
regards,
Kenny
View 14 Replies
View Related
Oct 15, 2007
Part of our product will be using several SSIS packages. One of our installers wants to be able to create a .cmd file that will run DTEXEC against one of the packages, with the correct config file specified. It had been assuming that SQL Server was installed in the Program Files special directory, but that's not always the case.
What is the correct way to locate the installation of SSIS? In fact:
What is the correct way to determine whether SSIS is installed?
What is the correct way to determine the version and SP that is installed (I want to require SP2)
I had been using the values under HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90DTSSetup until I found an SP2 machine with SSIS installed which did not have these keys. Where's the right place to look?
View 6 Replies
View Related
Jul 12, 2006
Hi,
I tried to backup the master key by the following syntax :
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'mypassword'
BACKUP MASTER KEY TO FILE = 'c: empmaster' ENCRYPTION BY PASSWORD = 'mypassword'
but it failed and i got the following message:
Cannot write into file 'c: empmaster'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.
NB: I am using the "sa" user to execute this command.
I know that we have a security permission issue , but where and how ?
Regards,
Tarek Ghazali
SQL Server MVP
View 12 Replies
View Related
Dec 8, 2004
Hi All,
looking for some views about where to place these catalogs. The manual says they work more effiecntly on a different drive to the database, which is understandable.
I'm in the processes of designing a new database application which is to be avaiable via the internet, and extranet app. But as I'm planning to host the app and the main database on a shared server but to have the catalogs on another server held in house. The app will have search facilities as its main use. They will obviously be some performace issues, but is this a good idea?
Thanks for any comments..
Regards
Davej
View 1 Replies
View Related
Sep 18, 2001
How to locate last occurrence of character in string?
View 1 Replies
View Related
Mar 8, 2005
Hi Folks,
Getting the following error after a DBCC CHECKDB
Server: Msg 8906, Level 16, State 1, Line 1
Page (3:15010) in database ID 9 is allocated in the SGAM (3:3) and PFS (3:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Trying to located the object that the allocation has gone to pot over.
Any quick way to resolve a datbase object using a page ID?
Thank In Advance
View 2 Replies
View Related
Feb 8, 2004
Hi
Im considering several options as to where to place the SQL Server and the web server in our organization's network I would like to hear your insights about the subject and the following options:
Option 1:
Placing the SQL Server inside the domain while the web servers are outside in the DMZ
Pros: SQL Server is in the domain, its harder to hack and its easier to manage inside the domain
Cons:the DMZ must allow access inside the domain so that the web servers can access the SQL Server this is not very secure.
Option 2:
Placing both SQL Server and the web servers in the DMZ
Pros: Fast access from web servers to the SQL Server. no traffic is allowed from the DMZ into the domain so the domain is completely secured.
Cons: The SQL Server is not very secured, its harder to administer it outside the domain.
I would love to hear of more options suggestions
thanks.
View 1 Replies
View Related
Dec 20, 2013
I am using SQL 2005 and I'm trying to find a T-SQL command that will allow me to retrieve a sub string based on the token. For instance, if I had a string like this:
abc^defgh^ij^klmnop^qrs
Let assume the token is the ^ and I want to get the string at the third token klmnop.
is there a simple one line command that I can use to retrieve this data?
View 3 Replies
View Related
Feb 28, 2007
Dear all,
I have installed JDE E1 Demo to my computer, which use SQL Server 2000. And the OS of my computer is Vista Home Prerium.
When I start the JDE, I met an error message, "Unable to locate security server". Cause this version of JDE could be running on XP, I guess if the problem is because of the combination of Vista+SQLServer2K.
I have checked that IIS is ok installed, the computer services are started automatically. But I have one strange phenomenon that after computer started, it seems that the SQL server service manager couldn't find the right server & service, so that server couldn't been started automatically.
Could you make some sense and show me some hint about this problem? Or could you tell me how the SQL service manager find the the server and service?
I have installed SQL Server 2005 in my computer but in different root, in addition.
Many thanks and Regards,
Viesta
View 2 Replies
View Related
Oct 15, 2006
Hi, as the subject suggest.
Thanks in advance
View 5 Replies
View Related
Feb 16, 2007
hello everyone,I am using VS 2005 and sql server 2000. I have a web application which uses a connectionstring with a user id and pwd. Everything is fine, I can execute normal sql statements from the code behind. I cannot execute a stored procedure...I get this error. Could not locate entry in sysdatabases for database 'exec usp_add2DB (my parameters are included here, deleted for simplicity reasons)No entry found with that
name. Make sure that the name is entered correctly. I have given execute permission for the user, and the name of the storedproc is correct. the name of the server is also correct....pls pls help me what is wrong here...
View 4 Replies
View Related
Jun 18, 2015
SQL SERVER 2008R2
The number of files to retain for SQL Server Logs is set to 99. When I expand the SQL Server Logs node in SQL Server Mgt Studio it shows the current log file through Archive#49. The oldest archive file is dated 2015/05/26. If I select that archive in SQL Server Mgt Studio it shows me the details and entries of that archive file. Yet when I go to the directory on SQL Server for the log files there are only the 5 most recent files. I have searched for '.trc' files on the entire drive and have found no other files.
How can SQL Server Mgt Studio show archive files that have no corresponding archive file in the directory that is supposed to contain the log files?
View 1 Replies
View Related
Feb 8, 2007
SQL 2k, DDL below.I have a simple table with the following data:fldYear fldCode1 fldCode22000 ABC1 ABC122000 ABC1 ABC132001 ABC1 ABC122002 ABC1 ABC122002 ABC1 ABC13I need to know, for every distinct combination of fldCode1 andfldCode2, if there are any years missing.For example,SELECT DISTINCT fldCode1, fldCode2 FROM MyTablereturnsABC1 ABC12ABC1 ABC13I need to know that in 2001 there was no entry for ABC1/ABC13Thanks!Edwardif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[MyTable]GOCREATE TABLE [dbo].[MyTable] ([fldYear] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[fldCode1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[fldCode2] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]GO
View 2 Replies
View Related
Jan 5, 2007
Access 2003 Data exported to SQL Express , great.
How do I then link the tables to the new database, I only seem to be able to link to system tables etc ??
Any ideas ?
View 3 Replies
View Related
Feb 14, 2008
My C# asp.net web application is throwing an exception and the message is the following:
RAISERROR could not locate entry for error 60002 in sysmessages.
The error occurs in the stored procedure. Can anyone tell me what I need to do to fix this problem? Note that if I manually run the stored procedure, I get the following error message:
Msg 2758, Level 16, State 1, Procedure GetPortalSettings, Line 74
RAISERROR could not locate entry for error 60002 in sysmessages.
View 3 Replies
View Related
Aug 7, 2002
Any idea what this error is?
error 911: could not locate entry in sysdatabases for database 'msdb'. No entry found with that name
Thanks.
Sa
View 1 Replies
View Related
