Paresh,

I have to say, I agree with Steve.

Since in his particular case, he don't continuous data refresh of production, I assume it is just once.

What Steve suggested,...

How about scripting all logins.

Right Click master database - Tasks - Generate Script

In Script Wizard. only set

Script Create True

Script Login True

remaining all other objects set it...

Simple Question :

Do I need to apply SP1, SP2 before applying SP3 on SQL Server 2005.

Why are you guys arguing ... if you know answer just share it, otherwise be...

If Restoring master database is your problem, then here is a short cut.

Step1 : Restore the master database backup you have right now with any database name ( say exampledb...

Hello

Like you said there is already a job which performs similar action,

why don't you script that job and see whats in that job. And depending on the new...

Thanks Jonathan.

I emailed Microsoft my questions , as soon I hear from them,... I will update this thread.

Thanks for your help.

Regards,

IM

Sp3 is released on Dec 15, not even a week ago...

We cannot apply SP3 on our server now... may be after a month or two.

Thanks for the advice....

Error Says, It cannot convert varchar to datetime because the date is trying to convert is overflowing... This usually happens when date is impossible, like Feb 30, Sep31 etc..

The only...

I will list some of the differences between Log Shipping and Database Mirroring which has not been discussed yet,

Log Shipping :

1. Not a high availability solution

1. Database can...

This Might Help.

This will compare two databases on the same server... similarly extend the code to compare two databases on different... Should be very easy...

This script will give...

Hi all,

I want to take log backups of 20 databases every 15 mins to the location 'Z:\backups\log\'

Its good you create Backup device,If not you will see these things,

1. normal...

You have to apply Service pack On Client tools.

I remember when I working from Clients tools SQL Server 2005 ( Windows XP). I wanted to edit a maintenance plan and...

Just a work around... to what you are doing now...

Apply full backup and apply all Transactional Log backups taken after Full backup.

If you have a media device then... you can...

GilaMonster (11/4/2008)

---

terryj30 (11/4/2008)

---

try this

1) dbcc opentran(dbname) - this will show the oldest open transaction

2) Kill this process

3) backup log dbname with no_log

4) use dbname

5)...

Yes you can, unless you want it. You can complete installation with only WIndows Authentication as well, if you decide to use windows and SQL Server Authentication then choose Both....