Adding database file

Question

Adding database file

Dathuraj Pasarge

SSC Eights!

Points: 807
More actions
March 31, 2015 at 12:05 am

#306178

Comments posted to this topic are about the item Adding database file
March 31, 2015 at 2:19 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Good to know. Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

An interesting question to be sure. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 3

I was 95% sure the answer would be "NO" because avoiding it would keep backup and restore less complex than they would otherwise have to be, while having it doesn't really add anything useful since adding the file before starting the backup if it is wanted in the backup is a reasonably convenient alternative for the DBA. So I picked that as my guess and it was right.

It's an interesting question, because MS doesn't always adopt what looks like the sensible and easy approach to SQL Server features.

Tom

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Good 2 know, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 5

RK Mandava

SSCarpal Tunnel

Points: 4153

March 31, 2015 at 7:07 am

#1787687

interesting question... thanks

webrunner SSC-Dedicated Points: 31880 More actions · Answer 6

Thanks for the question! I got it wrong but learned something.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 7

I think the reference link which you posted is not appropriate.

USe this:

https://technet.microsoft.com/en-us/library/ms175477(v=sql.110).aspx

Thanks.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 8

SQL-DBA-01 (3/31/2015)
I think the reference link which you posted is not appropriate.
USe this:
https://technet.microsoft.com/en-us/library/ms175477(v=sql.110).aspx

I think the link is appropriate.

https://msdn.microsoft.com/en-us/library/ms189253.aspx

or

https://msdn.microsoft.com/en-IN/library/ms189253%28v=sql.120%29.aspx

It has the below statements

"

Limitations and Restrictions

You cannot add or remove a file while a BACKUP statement is running.

"

dstrickrott SSCommitted Points: 1951 More actions · Answer 9

I learned something from this. Thanks for the question Dathuraj.

Ken SSCoach Points: 17191 More actions · Answer 10

Interesting question. I figured I would get it wrong and that SQL Server would have a strange option to add a file during backup. Doesn't seem like a reasonable thing to do imo but that doesn't mean MS wouldn't allow it! Glad that there were no tricks here. 😀

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

akljfhnlaflkj

SSC Guru

Points: 76202

April 1, 2015 at 6:40 am

#1787991

That makes sense. Thanks.

WACIII Say Hey Kid Points: 669 More actions · Answer 12

My thought when reading your comment is what I considered to be a slightly ambiguous understanding of the question text when I first read it. I.e. did the question indicate some kind of Backup option by which a new Log File could be added, or could a new Log File be added by an external process while the Backup process is executing.

Or I could have had temporary brain-deadness when reading the question.

Bill