Is this possible? I can only seem to restore when the *.bak is on a local drive which is ridiculous. I'm sure this translates to other operations in addition to restoring databases...
View 7 RepliesPls explain how to backup and restore data on SQL Server with a CD drive instead of tape drive.
This is urgent.
Thanks.
Hi
I have been trying to use openrowset with a shared drive, and even though the share has "full control" permissions granted to "everyone" and the accout that SQL runs under has been granted explicit full control permissions I am unable to open the file which itself has no security on it.
Can I not use a \ path and only use mapped drives?
Thanks
below works...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:5People.xls', [Sheet1$])
below doesn't work...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\cluster02FileManager5People.xls', [Sheet1$])
Hi,
I have a shared drive mapped to the h: drive letter on my sql server and I want to create new databases on that drive. Is this at all
possible?
I try it and I couldn't see h: even if I typed it in.
Thanks
Hello, everyone:
I want to write a query to check a remote shared drive. The shared drive is mapped as T drive in my local. I run the statement,
EXEC master.. xp_cmdshell 'DIR C:'
It works. If I change to T drive like,
EXEC master.. xp_cmdshell 'DIR T:'
It dosen't work and returns,
"The system cannot find the path specified."
But I run DIR T: in DOS prompt, it works.
Any help will be great appreciated.
Thanks a lot.
ZYT
I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.
Thanks
I know , it is not going to work , just wondering if anyone could give any reasons for that. Whether it was intentional constraint or just internally compact edition was designed in particular way which makes such a usage not possible. It is a pity that it doesn't work that way as it would be much easier transitional path for many Visual Foxpro , MS Access applications.
In my case I just want READ-ONLY database either for multi-user access via shared drive or stand-alone on local drive.
I've one table which is contains sales Tax data and I need to send data(only for past month) to accounting person by every end of the month for Example. Today is July/1/2015 so I need to send data for month of June/2015.
Is there anyway I can setup a job to send a data. Also I am not able to send large file using OUTLOOK so is there any other Tool to send a data?
Hi
I am having an Access database on a shared network drive which has read/write access rights on the that shared network drive.
When I try to Access data through the linked server it gives me gives me a message box saying you do not have permissions to view the data.
Also if i try to use xp_cmdshell to copy over the mdb file to my local drive it say 'Access denied'
But when I copy (through command prompt) the same file to another network drive or my local drive where I have full control the linked server can connect sucessfully.
The problem is the i cannot have 'full control' permissions on shared drive where my database resides.
Has anybody encountered this problem....
Any help will be greatly appreciated.
Urgent
Puru
Is there a way to get access to the files on the shared drive from either of the nodes when the SQL Cluster is shut down?
It doesn't look like there is, but hoping there is some trick. I see how it can be done with a Windows Cluster but not a SQL Cluster.
Can you restore the master database, running on windows server 2000, sqlserver 2000 from a backup that was taken from c: to another serverrestoring to d:?*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedHi All,
I took a backup of master,model and msdb database which was on D: drive and i tried restore it on C:. Now if i try to start sql server it comes out with a erorr that model database cannot be found and it keeps looking for model in D: drive which is not there.I tried restore of model with move option but it says cannot drop model as its system database.I tried attach detach but it does not understand tempdb as temp db is also on d: and i cannot understand how to move or point it to c:
Suggestions will be greatly appreciated
Vishal
How to backup half of dbs from a server on C drive and the other half on D drive and vice versa, first half on D drive and other half On C drive using only one job and one stored procedure??
Using scheduling from job add 2 schedules to the job so first schedule backup first half to C and second half to D , the second schedule backup first half to D and second half to D.
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 RelatedI'm currently on a shared hosting plan which has a SQL Server component to it.
At the moment, I'm on 2000. I have a DTS package that runs locally and does a backup of the remote database and backs that up using sequential file numbering.
I'd like to move to 2005, but I'm not sure quite how to replicate this process. Basically:
- I don't have access to the server as it's shared hosting
- I don't have the credentials for backups and stuff like that
- They only send backups on demand
- They don't perform regular backups on your data
- They won't have the backups saved to my web directory
If I:
- use import/export, which is almost the only thing I know I can use, I can only copy tables and views. I'd like to copy everything (SPs, Functions, ect)
The only thing I can come up with is software that would compare the structure and data and generate T-SQL to copy it over (ie. Apex SQL).
Is this my only hope on SQL 2005?
I have a utility I wrote which can backup/restore my database as wellas schedule backups. This has always worked pretty well except when Itry to backup to a USB Flash Disk. When I use one of these the backupfails. If I backup to the C:/ drive then copy it over to the disk itworks fine but when SQL Server tries to do it, it can't.I am simply doing the following:BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INITAnyone know what could be going wrong?
View 3 Replies View RelatedWe're trying to backup some dbs to a network drive but fail.
I read that the 'a/c to run SQLAgent must be a domain user a/c with
proper permission to access the network drive.'
What is proper permission? Read, Write ?
Only the a/c that runs SQLAgent needs the proper permission, the job's owner doesn't?!?
Thanks in advance,
Ben
Hi guys.
Has anyone ever done SQL DB backup directly onto a maped network drive?
We've got a really huge DB 100GB+ that just wont fit into the local Hard Disk for backup.
Thank you in advance for your help.
Cheers,
Stephen
I have creted a backup device on network drive and getting the following error when I run the backup command as a job.SQL server and the agent are running on a domain account which has full permission on the network drive.Any help is greatly appreciated.
Thanks!
"Cannot open backup device 'mccdiffbkpond2build'.
Device error or device off-line. See the SQL Server error
log for more details. [SQLSTATE 42000] (Error 3201) Backup or
restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed"
I am setting up a backup on one of my DB's and the network drive does not appear as an location that I can backup too. Only the C drive is present. However, on the server I do have a drive mapped to the network drive, so it should be available. Has anyone encountered this issue before?
Thanks!
Scott
I want to perform backups to a network drive. I need to know if I can access the backup drive via UNC. I have not been able to get it to work and, for now, I would just like to know if what I am trying to do SHOULD work.
For example I want to backup to device mdtnts_prod02LM2BackupNameBack.DAT.
Thanks,Bob
Hello,
I'm looking to get the drive letter and path for my backups programmatically. I am monitoring my sqlserver boxes remotely and need to get this information to determine if my backups will fit on the backup drive.
I'm looking for either a sql statement or a stored procedure to accomplish this.
For example...the backup script states:
EXECUTE master.dbo.xp_create_subdir N'H:MSSQLBackupmaster'
I need to know how this script gets H:MSSQLBackup
Thanks in advance.
Hi there,
Does anyone know if it's possible to perform a MSSQL7 database backup on a network drive instead of the local drives ?
...and if yes, how to proceed ?
It seems to be possible under MSSQL2000.
Many thanks for your help in advance,
Matt
i have taken full database backup on tape drive one week ago,by automated scripts ,now when i check the maintenance plan history , it says the task failed and gives a message that unable to open the \. ape0 ,with error
([Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\. ape0'. Device error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
)
HI
i am trying to take a backup on Network drive but i am getting following error message. althought when i try to type the address in window explorer. i can access the specific folder. so that there shouldn't be network security issue.... and even thought the backup device name is correct.
when i try to take backup on local disk, it work's fine....
Executed as user: NT AUTHORITYSYSTEM. Cannot open backup device 'FullBackup(\0.0.0.0SQL_BackupsFullBackupsFullBackup.bak)'. Operating system error 5(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
First posting to the group. I have received a lot of valuable info from youguys. Now, an OT question:What's a good tape drive to perform unmanned weekly backups for a WindowsXP Pro box running SQL server 2000?--Joel Farris | AIM: FarrisJoel** Their Web. Your Way. http://getfirefox.com **
View 1 Replies View RelatedI am using SQL Server 2005 Express Edition. I am planning on upgrading to either Workgroup or Standard edition. While working with Express Edition I did find out that this version does not support backup to a network drive.
My question is:
Is it possible to backup directly to a network drive using a Workgroup/ Standard edition of SQL Server rather than backing up to a local drive and then 'copy and paste' to a network drive like the Express Edition.My other question is :
Given a database limit of 50GB, which one of the editions, Workgroup or Standard, will be appropriate for use.Thank you for your time and patience.
Regards
Berly Sam
Hi,
I have created an sql server 2005 maintenance plan for a daily backup. The plan has two 'Back up database task' i.e. one backup on the local drive while the second on a network drive. When the plan is executed, a backup is created on the local drive but not on the network drive. If i check the log, it says "Access Denied" whereas i have full access to the network drive with complete permissions to read, write and delete.
Can anyone help me understand how to take a backup on both a local and network drive at the same time using a maintenance plan ? I shall be obliged...
Regards...
I currently have a SQL backup process that backs up my databases via the network to a backup hard drive on a separate system. I recently began getting strange issues with my backup process in which it continually writes to the backup drive until the drive fills up and then the job fails. I also noticed that when I kill the job on the host server, the backup file drops to the normal file size. The normal file size is 300 GB but it has grown to over 400GB. I looked at various logs and even performed several backup tests with success.
I am trying to figure out if this is a known SQL Server issue or an issue with the OS?
specs:
windows 64bit/sql server 2k5 64bit
Thanks in advance for the help.
We are attempting to restore one of our databases from a backup that went to a local drive on the server.
We see the backupset in the list but receive an error that it is not available when we try to use it. When we try to restore from device and select the files the drive letter is not available. When we attempt to enter the path to the file it can't locate it. We don't have space on our SAN to copy the backup there and we can't add the local drive to the cluster resources.
Is there a way to get this backup done?
HI everybody,
I have a problem in restoring a backup. In the restore command there is one option called <file> = 'file_number'. Where do we get this 'file_number'?.
tks in advance
Srini
Hi Everyone, I was prototyping a DB and made a backup of all the files in the data directory of sql server, thinking that I would be able to restore the system from another installation when I made it to the US. I have the cd with the archives on and a full backup of the DB I want but I have no idea how to get sql server to initialise it.
Any ideas???
Steve
Guys, i've 1.6 GB of backup size and it takes 1 hour for this backup to get restored over a SCSII 10,000 rpm.
Is it normal. How can i make the restore faster.
It takes only 5-10 mins to take the backup however.
I am restoring the full backup, no differential or log file.
Howdy!