-
Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...
Last updated: -
Back-up copies of the database
We have an access database that has multiple users for data entry. without fail, we end up with several "back-up" copies. Is this the result of the different users "saving" or is it from having shortcuts on their individual laptops?
Last updated: -
SQL Server 2008 database backup terminating abnormally
I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...
Last updated: -
details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?
Last updated: -
Backup and Restore different SQL Server 2012 Editions
Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.
Last updated: -
Can I backup database with exception tables?
Last updated: -
Restoring a backup from Brightstor 12 server
Can we restore a backup from a Brightstor 12 server without the database? What would be the procedure for that?
Last updated: -
Backup/recovery across multiple schema
What is the best strategy for backup/recovery of multiple schemas in a database
Last updated: -
I'm looking for a hardware base dedupe backup solution that does not require additional licensing.
Last updated: -
What might be the problem for when i go to shut down my computer and all it does is get rid of all icons on desktop, keyboard & mouse unresponsive? But then i hit reset button and everything works again. But also takes forever to start up, what might these problems be, and how could i fix them?
Last updated: -
I'm attempting to use Data Juntion to create a reference table (DB4)from a proprietary database to use as input to a reporting appliation. I need to create between 1 and 12 output records from each qualifying record from my database. Is this possible in Data Junction? Thanks!
Last updated: -
I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in time,...
Last updated: -
What are the different ways to know if DB backup & archive log backup process have hung. How can we know the average run time of db backup & archive log backup ? What are the advisable checks to be performed / steps to be taken if we observe the backup is slow (determined by average) or has hung.
Last updated: -
We are running a mission critical application on Filemaker. The FileMaker server, a Dell Poweredge 2650, is configured to conducts scheduled backups 5x daily. However, the backups are saved on the server itself. We want to move the backups to the SAN and conduct the backups at non peak usage times....
Last updated: -
Deleting Nightly Database Backups (dumps)
How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday
Last updated: -
Reduce database size for archiving
I have one database thta have lage size,now i am trying to archive that database,I al ready reduce 40,000 documents from that databse to archive Dbase,but still the database size is same, some please guide me it very urgent
Last updated: -
Oracle archives are not moving from primary to standby database
Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?
Last updated: -
Permissions for writing stored procedures in MySQL
Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I...
Last updated: -
SQL Server database backup (URGENT)
Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup...
Last updated: -
automate Oracle database backup on Windows 2000 server
Hello, I have to make a cold backup of our test database. The database is oracle 8.1.7 on a Windows 2000 server. I have made bat files to do this and have scheduled them in the Windows scheduled tasks application. This works fine. I check to see if my jobs have run successfully by looking the the...
Last updated: