I've had similar problems a few weeks ago when a supportdesk just deleted the logfile because that was the standard procedure for the company in these situations.

Same situation as the...

You could use Powershell to do this. You can execute the qeuries from the powershell script and save all the values on the central server.

You can find more resources at...

This the format:

Test_20090724230001.trn

Test_yyyymmddhhMMnr.trn

yyyy: year

mm: month

dd: day

hh: hour

MM: minute

nr: first number in that timeframe.

So the log backup should have started on 23:00 that evening.

The need for this skill will always be there. GUI build queries tend to have to much overhead in some cases and if you know how to write the queries...

In my company passwords are created randomly and every serviceaccount or login has a different password. We do store the passwords but we use KeePass to store them in.

In...

Congratulations!

Could you try to have the following startup variables:

-dF:\master.mdf -lF:\mastlog.ldf -eJ:\errorlog\errorlog

And move the mastlog.ldf to the same directory as the mdf file.

You can easily restore SQL 2000 backups to a SQL 2005 server. The only thing you have to check is that all your logins are on the other server. If...

Can I use Derek's new capability to power my USB powered fan? My company wants to cut down in energy costs 😉

I think it's more the chicken and the egg story.

Employers don't hire you when you have no certification. But if you don't have enouph experience you can't get the...

Derek the robot will probably do this:

BACKUP LOG dbname WITH TRUNCATE_ONLY

DBCC SHRINKFILE(dbname_Log, 1)

And then suddenly remind itself that the database has become corrupt 😉

I usually go to SQL Server Central but I'm also active on Experts Exchange.

Funny !!

There are ways to do this with Vista but you'll having a lot of work getting your cluster working and there is no garantee that you'll succeed. Windows Vista was...

fhooglander (7/14/2009)

---

I've had this same issue. This isn't really related to just clusters. It's the same on a stand-alone SQL Server 2005 that does not have a power of 2...