Database

Database

Hello,

I have a server with Windows 2003 Server installed and inside the server, I installed several applications and one of them is MS SQL Server. I'm using MS SQL Server for a custom desktop application that I developed and for some time everything works great with no problem whatsoever.

Lately, I'm considering changing the database from MS SQL Server to MySQL so, I can access the database from around the world. Unfortunately, it means I need to adjust some things to make the desktop application work fine using MySQL like when it used MS SQL Server for the database. Using the same desktop application I can access and manipulate databases inside MySQL without having to develop new applications for it.

  • 985 views
  • 1 answers
  • 24 votes

Hello,

I am a student. I am naive in the computer world as well as software section. Now a days I am studying Microsoft SQL server. I am using Microsoft SQL server 2005 edition. I have a database mdf file and log file. I need to attach those files again in the database. As my SQL server is new, this database is not there. But I don’t know exactly how to attach a database.

Can anyone tell me?

Help me please.

  • 1087 views
  • 1 answers
  • 24 votes

Hello!

The following databases are running on my computer:

Informix DNS 10.00FC8 with Linux RedHat

MS SQL Version 2008 Express running on my Windows 2003 R2 SP2

And lastly, I am running IBM client Version 3.5 TC4 when connecting with Windows Server to Linux. I configured the Informix and linked the server to SQL with the help of OLE Database for ODBC. It was working but it failed on completion. I need to use the OPENQUERY in SQL to make it work flawlessly. I want to know if it is just fine to and if OPENQUERY is working better than selecting it in the simplest way.

  • 1737 views
  • 1 answers
  • 22 votes

I've made a little progress with packaging and making a runtime file for my Access 2007 app using Microsoft info pages. But for some reason, I'm getting a blank application when I test-package it and then tried and run the file.

  • 5623 views
  • 2 answers
  • 22 votes

Hey guys,

I have deleted an oracle data file. But it seems I couldn't completely remove it because when I'm trying to make a new one with the same name oracle says: "data file already exists !!!" What to do?

  • 1044 views
  • 6 answers
  • 13 votes

Hi all,

I am having problems removing a data file in oracle database. I removed it but when I tried to make one with the same name then it said that "data file already exists".

But how it can exist when I personally deleted the file?

Can anyone help me?

  • 2142 views
  • 1 answers
  • 22 votes

I have installed MAMP yesterday, and had it working great. Was very impressed. Then today I got to start working on a new template and I got the Error Message: 

  • 2748 views
  • 2 answers
  • 24 votes

Can any one help me altering an Oracle table? I have made a table and it has some data in it. But unfortunately, I forgot to make any primary key on that table. Is it possible to make a primary key now? I don't want to delete my previous data, that is already in the table.

  • 1616 views
  • 6 answers
  • 22 votes

Our company uses Microsoft SQL Server 2005 as the database management system. We have several databases hosted on it. Everyday we create a scheduled backup using the Microsoft SQL Server Agent. The backup runs at 7 pm every night. Each backup runs up to around several gigabytes. We need to retain only 2 days backup on the production server and overwrite the older files. How do I go about doing a rolling backup for databases in Microsoft SQL Server?

  • 2837 views
  • 8 answers
  • 24 votes

Hello,

I am using Microsoft SQL Server 2005 edition. I want to restore a database. I have the backup file for my desired database. As i am new to SQL Server, I can not restore this back up file as a working database. I need help to restore this.
 
One thing should be mentioned is that the restored database must do as it did before. Can anyone tell me how can I restore the backup file as a database in Microsoft SQL Server 2005?
  • 958 views
  • 2 answers
  • 21 votes

Latest Articles

Benefits Of Storing And Sharing Documents In The Cloud

Have you ever wished you could access your important documents anytime, anywhere? With cloud document storage, that wish becomes a reality. In today’s fast-paced world, secure and accessible document management is more essential than...

From Lost To Found: Restore Your Data On Windows 11

Are you worried about data you lost during some operation on your Windows 11? Don’t worry; we are here to guide you on how to recover the lost data from your Windows device in...

How To Differentiate Demand Generation From Lead Generation

Lead generation and demand generation are two of the business strategies that help businesses grow. It creates a pipeline of interested customers looking to find out more. Lead generation on the contrary, is able...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...