chetanr.jain (11/3/2010)

---

I am using SQL Authenication while connecting to secodary server.

Does that will have any issue.

The sql login is part of sysadmin group.

Also, i have created script from the log...

chetanr.jain (11/2/2010)

---

Hi,

I am trying to configure Log shipping on two sql 2005 enterprise servers.

There is no error shows in the wizard.

But after the wizard get closed, Backup job is...

Check with below MS link

http://technet.microsoft.com/en-us/library/aa337272.aspx

Did you recevie this type of error perviously ?

What's the DB size ?

Backup Drive have has sufficient space ?

Sais (11/2/2010)

---

Hi,

I dont think my MDF file (46GB) is actually holding that much information.

Why? Cause my Recovery Model is FULL and my LDF file is now under 5MB

First why do...

Sais (11/2/2010)

---

Database Recovery Model = Full

Yes, Transaction log backup are being taken via Maintenance job and its now down to less than 36MB

But the Data file is still between 40...

Read the Jonathan's article[/url]

For better clear

Sais (11/1/2010)

---

Hi,

I have got a production database about 50GB and a transaction log 21GB

I did DBCC shrinkdatabase and DBCC shrinkfile on both database and the transaction log- files

This gave me...

Ur welcome.

Duran (8/10/2010)

---

Hello,

I wondered if anyone out there could share some wisdom in regards to DB compatibility levels.

I have a few databases on level 80 on SQL 2005, and I think...

harit79 (7/24/2010)

---

Hi to all.

This is my first job.

Basically i am an Oracle Certified Professional worked 1 year as a Developer and now i switch my job as a SQL Server...

rambilla4 (5/5/2010)

---

Hi,

We have SQL Server 2005 EE 64 bit with service pack 3. The tempdb log file size growth is 600 MB a day. I did not understand why this...

Its MS rule of thumb.

What's 10G...

Go & look the BOL 😀

select [error_message] from msdb.dbo.sysmaintplan_logdetail

where succeeded =0...