If you are backing up your database logfile, at that point the data is essentially wiped and is recalimed as empty/free space (ie there is no data). At this point...

durai nagarajan (4/9/2010)

Server is on windows 2003 SP2 and SQL 2005 sp2 suddenly not showing green icon near server name , neither on sql agent also. i coudnt get option...

Is the database that uses this logfile in FULL or SIMPLE recovery mode?

If its in FULL mode are you backing it up regularly?

If i understand you right, you want to...

A bit confused as to what you want.

A) Are you saying the you want to truncate a table and it records that are older then x?

B) Or do you...

I dont believe this is possible. The compare program is greate but the functionality of what you can get it to do is quite basic.

Having said that, if there are...

Hey Guys,

Sorry if i have misunderstood btu what i think you asking is quite routine. The databases from two servers are to be mirrored onto a third server (DR)??? If...

Bhuvnesh (3/19/2010)

vmssanthosh (3/19/2010)

But you do not have to be rude like this.. you could have just ignored his post.. thats how people starts here... At the start itself no body...

newbie2sql (3/18/2010)

We would like to refresh our dev database from prod. Before that we want the users to have the same permissions after the refresh also. Because...

If its only very occasionally i wouldnt really worry (but keep it in mind cause its a sign that you may need to consider consolidation or memory upgrade).

What is the...

The Page Life Expectancy is basically how long a page remains in memory (seconds). It is a sign that you do not have enough memory for SQL. If for example...

What is the package? What does it do? Did you try taking out the second step in the job (how does that effect it).

I have a package that does a...

Did you look at the diskk space on your mirror box? What was it?

Also you can look at the size of the log file on the mirror (it should be...

I suppose it really depends on how granullar you want to get or rather how granullar your organisation wants it to be.

For example, we have a DBA's group and SQL...

Thanks Steve.

Sorry cant share package, too much sensitive info to release and...

SQL backup files? Why dont you just write a batch file? If what you want is a nightly scheduled job to move files offsite (once created) i would suggest using...