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...

SQL Server Ask the Experts2,585 pointsBadges:

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?

Joyrider64825 pointsBadges:

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...

Tablestructure15 pointsBadges:

backup and recovery

details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

Onlyplsql5 pointsBadges:

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.

TLMercer45 pointsBadges:

Backup database

Can I backup database with exception tables?

Bjet55 pointsBadges:

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?

NewnanIT1,110 pointsBadges:

Backup/recovery across multiple schema

What is the best strategy for backup/recovery of multiple schemas in a database

Backup105 pointsBadges:

Deduplication Backup strategy

I'm looking for a hardware base dedupe backup solution that does not require additional licensing. 

Mgtow5 pointsBadges:

Missing Icons on Desktop…..

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?

Jreifenstein001185 pointsBadges:

Data Junction 7.0

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!

Gegrobe5 pointsBadges:

Database restore

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,...

Thedbaed5 pointsBadges:

DB backup is hung

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.

Jayeshmb15 pointsBadges:

FileMaker Pro v8 SAN Backup

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....

MPDIT55 pointsBadges:

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

637815 pointsBadges:

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

772620 pointsBadges:

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?

OracleATE190 pointsBadges:

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...

Ktrramu5 pointsBadges:

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...

Plugsharma40 pointsBadges:

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...

Mariane10 pointsBadges: