Have you ever thought of Raplication?

sanketahir1985 (1/31/2010)

---

Ok

Let me tell u my scenario.

we hav 1 sql server 2000(srv1) on which database db1 is located which is OLTP DB,

in that there is table tb1 in which frequent...

Tara-1044200 (2/1/2010)

---

I have a database of 950GB in production and also have same copy in development, everytime i have to load data into the datrabase i do it on development...

Right.

Puneet Brar (1/28/2010)

---

Dear all

i have a server for windows 2003 and sql server database 2005 and have around 10 database

and also i have the same server lying in canada...

This is what MS...

river1 (2/1/2010)

---

Master, thank you for reply.

I undesrtud almost every thing, but i have a dought about the SQL Server service and the SQL Server agent service account.

As i told. I...

river1 (2/1/2010)

---

Thank you very mutch for reply.

What i really want is that NO windows account (domain admins or domain users) can access the SQL Server 2005.

CAn they have...

Yes you are right you have to remove Built-in Admin account from SQL Server. In fact Microsoft advises to remove it to tighten the security. A few months back we...

MSDN says...

Possible Causes

This message might appear because of one of the following problems:

You have installed BI Development Studio but you have not installed Integration Services. Running packages outside Business Intelligence...

If you have sys admin rights, you should be knowing the physical location of the folder at the server. Just go to the server, right the folder and select the...

1.Remote logon to your SQL Server box

2.Start > Programs > Administrative Tools > Services

3. Look for the service "SQL Server Agent (MSSQLSERVER)"

4. Right click the service and select "Log on"...

Okay I ran following query against table1 which has 10 rows:

select 8 from table1

It returns a single column result with 10 rows with each row having value 8 in it....

May be a permission issue. Check the permissions of the service accounts of sql server. If you are running the backup in a job, make sure that the account under...

This is what learned from my experience.

If you worry too much about future, you cannot do best in present.

Follow your passion, be it DBA, System Admin, Architect, Programmer or whatever...