I have a table with 2 columns:
For sql server 2000 I never used the maintenance plan, I always used jobs to solve my maintenance problems.
This year I will migrate to the...
Last week last I passed an interview for a junior dba sql server job and the dba asked me these questions.
1.You#%92ve been given the task of...
Please, I need your help.
I am a junior dba sql server and I want to know if I must install oracle client to connect to an oracle database, with...
Can somebody tell me if I can implement a SAN solution with sql server 2005, STANDARD EDITION or it work just with enterprise edition?
I need your help, please!
I my aspx page I want to retrieve information from my sql server database and I don#%92t know how to select products...
I am looking for a solution to my problem.
I have two servers, a production server and a drp server. Every day I must create a backup for bd1 on...
I have an application that use a stupid replication with source and target database on the same server.
Now I want to test my restore plan and...
I want to buy software to manage the performance of my 25 sql servers 2000.
Can you suggest me something, please?
Thanks in advance!
My company plan to use an application that will use a transactional replication (on the same server!!!).
For me is for the first time when I...
I want to know if I can do a replication between two databases on the same server(same instance) and between two databases on two different...
I want to know if a can run a cmd file via a job and if yes, how.
Thanks very much
I have a database on one server (db_prod) and I have a copy of this database on a standby server (db_prod) but I don#%92t have a test server....
How can I use local packages in an external scheduler?
For all jobs in the company we use an external scheduler (CONTROL M ).
Once per week I...
Hi,<br /><br />On the serveur1 I have an application that uses a sql database.<br />If any problem, I want to change server 1 with server 2. For that...
I have a maintenance plan and implicit a daily backup, at 22 PM.
I want to take this backup (the last backup from device), to zip and to send...
How can I create an alert to test if the database is up?
I am beginner in sql server.
Thanks in advance,
I am not able to restore my database. The backup file is on one server and the database is on another.
When I click on: restore...
I have to manage a SQL Server DB who is used by a web application - server A. We have also an other server for special situations (disaster, for...
I am in charge with the administration of a sql database (I am in charge since a few days and I#%92ll start a course in a couple of weeks)....
Separate names with a comma.