Btw: a file backup of an active database is NOT the advised way to create a database backup!!

When a database is ONLINE the databasefiles will be locked. Some (backup)tools take...

You can just execute a SQL native (or third party) backup without users noticing anything. Database just stays online and available and users can still perform actions without problem.

I've been in different companies and every company has it's own setup. Lately I see more and more third party software like TSM and the database backups done by a...

DBA From The Cold (9/23/2014)

---

....If your diff backups are taking longer, can you schedule them to run more than twice a week? They would then have to backup less changes...

Did you look at the code the...

Here's a simple sample:

if not object_id('tempdb..#values') is null

drop table #values

create table #values (daily_date datetime, value int)

insert into #values

values('20140810', 20)

, ('20140811',40)

, ('20140812',80)

, ('20140813',70)

, ('20140814',70)

, ('20140815',60)

SELECT

cur.daily_date as 'today'

, prev.value as 'yesterday_value'

, cur.value...

TomThomson (9/23/2014)

---

Ah, all becomes clear. The thread wanted a companion, so it inserted itself between some spam threads to...

If you didn't have active monitoring/tracing on activity running on the server it will be impossible to get the root cause. There is basically no way to see how/what (DML-)actions...

I can think of several options:

1. the easiest is to include the backup date/time in the backup filename. This will generate unique filenames so existing files won't be overwritten with...

Now that's an attidude I wish other departments...

I have the same issue for thread "Are the posted questions getting worse". I also don't find the thread in the list anymore.

Your referring to the four-part notation. The correct notation is [instance_name].[database_name].[schema_name]..

To be able to use this accross different instances a linked server connection is required from the querying instance to...

From the leaving DBA's point of view it wouldn't give me a confident feeling when the OP is reverting every question to this forum.

GilaMonster (9/19/2014)

---

Someone's either having the worst day, or is asking interview questions.

Database goes into Restoring mode

Performance tuning it so critical can any one plz figure it out urgent ...

And btw: a database doesn't go "just in to restoring mode". An action is required to...