Hi,

you can backup db on production and copy .bak file to dev env and then restore it there?

You can compress db bak file, zip it and then copy it to...

• This reply was modified 1 year, 6 months ago by  SkyBVI.

Thanks.

We are planning for Failover cluster.

Regarding point 3.

You mean SQL updates(ex  edition, upgrade, patches etc) and OS updates will have to be done on both nodes separately

and within sql instance...

jasona.work (9/25/2012)

---

I'm not sure what you mean by "SQL Services has no items under it."

If you mean you've gone into the Configuration Manager, and there's nothing listed when you select...

yes bret

jasona.work (9/25/2012)

---

Couple possibilities:

1. Unless you changed the option during install, you actually will need to connect to {Computer Name}\SQLExpress

2. Check that the SQL Service is running (based on...

cphite (9/25/2012)

---

SKYBVI (9/25/2012)

---

Hi,

I have installed sql server 2008 express edition with managemnt studio successfully on my local pc.

In the connect to server dialog box in starting...

options...

I am getting error as attahced.

Regards

Skybvi

ya i got it now...

thanks all of you for helping me out..

Regards,

Skybvi

ravisamigo (7/16/2012)

---

Hi All,

We have configured 2 jobs for db full backups and both jobs having the same number of databases

[ i.e JOB 1 - Total size of all...

Elliott Whitlow (6/14/2012)

---

SKYBVI (6/14/2012)

---

Hi,

I have 3 doubts :-

1) If I have a SSIS package with encrypted package protection level and in data flow tasks,...

Thats true I agree,...

Some questions whcih were asked by interviewers :-

1) Why clustered index are only 1 and non clustered indexes are many?

Also, if for a table we have...

Brandie Tarvin (5/30/2012)

---

SKYBVI (5/25/2012)

---

Hi,

I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of the...

Thanks a lot

Regards.

Skybvi

Thanks a lot

Regards.

Skybvi