-
- Veteran
- Posts: 295
- Liked: 59 times
- Joined: Sep 06, 2011 8:45 am
- Full Name: Haris Cokovic
- Contact:
SQL U-Air issue
Hi there,
don't know if anybody else is seeing this behaviour. Got a little issue with SQL U-Air (well i think it's an issue ).
We've setup a SQL 2008 Server which contains a single Test DB that gets filled up with useless data for testing purposes. So every day a table with 2 columns gets created (id and create). These columns are defined with id(int, not null) and create(datetime, not null). So in both cases nulls are not allowed.
If i perform a restore of any table (no matter which one) everything works fine and Veeam tells me that the restore was performed successfully. But if i take a deeper look at the restored table respectively into the columns they are now stating as id(int, null) and create(datetime, null).
I've opened a support case and we had also few remote sessions over it. Now the final answer after some research is:
This is intentionally. So it's not a bug it's a feature
Original case id is 5148142. I've re-opened the ticket and the new case id is 5173268.
Would appreciate some more information on it as right now this feature is not usable for us in our production environment.
Thanks in advance for any help.
don't know if anybody else is seeing this behaviour. Got a little issue with SQL U-Air (well i think it's an issue ).
We've setup a SQL 2008 Server which contains a single Test DB that gets filled up with useless data for testing purposes. So every day a table with 2 columns gets created (id and create). These columns are defined with id(int, not null) and create(datetime, not null). So in both cases nulls are not allowed.
If i perform a restore of any table (no matter which one) everything works fine and Veeam tells me that the restore was performed successfully. But if i take a deeper look at the restored table respectively into the columns they are now stating as id(int, null) and create(datetime, null).
I've opened a support case and we had also few remote sessions over it. Now the final answer after some research is:
This is intentionally. So it's not a bug it's a feature
Original case id is 5148142. I've re-opened the ticket and the new case id is 5173268.
Would appreciate some more information on it as right now this feature is not usable for us in our production environment.
Thanks in advance for any help.
-
- Veeam Software
- Posts: 21138
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL U-Air issue
Haris, this is actually an intentional behavior. There are two separate SQL item-level restore operations: schema restore and data restore. When you restore data, the schema (null/not null) is not restored. And vice versa, if you restore DB schema, data will not be restored.
-
- Veteran
- Posts: 295
- Liked: 59 times
- Joined: Sep 06, 2011 8:45 am
- Full Name: Haris Cokovic
- Contact:
Re: SQL U-Air issue
Hey Alexander thanks for explanation. Will give it a try and test it.
Was just a little bit irritated as the last statement just was that it's intentionally with no other explanation
Was just a little bit irritated as the last statement just was that it's intentionally with no other explanation
-
- Veteran
- Posts: 295
- Liked: 59 times
- Joined: Sep 06, 2011 8:45 am
- Full Name: Haris Cokovic
- Contact:
Re: SQL U-Air issue
Okay got to start reading the manuals more carefully. Thank you very much for the hint Alex. No issue at all from Veeam
-
- Veteran
- Posts: 295
- Liked: 59 times
- Joined: Sep 06, 2011 8:45 am
- Full Name: Haris Cokovic
- Contact:
Re: SQL U-Air issue
Just a little update on this. Today i had a remote session with the support and received a personal hotfix for it. Now it's working as i expected it. The table gets restored with its original settings.
Love your support. Great job
Thanks,
Haris
Love your support. Great job
Thanks,
Haris
-
- Veeam Software
- Posts: 21138
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL U-Air issue
Haris, could you please elaborate regarding this hotfix, what does it exactly do? Previously you've stated that there was "no issue at all from Veeam" so nothing to be fixed, I suppose.. Does it allow to perform data restore along with DB schema restore as a single operation? Thanks!
-
- Veteran
- Posts: 295
- Liked: 59 times
- Joined: Sep 06, 2011 8:45 am
- Full Name: Haris Cokovic
- Contact:
Re: SQL U-Air issue
Hi Alexander,
i've stated this before cause i wasn't aware that two steps were needed. One for schema restore and the second for the data. I was surprised as your support offered me a patch for it. Seems that you guys discussed it internally and decided to change the behaviour. So yes now if i restore the table the schema gets restored too. As i've been told it's going to be changed in a future release too.
i've stated this before cause i wasn't aware that two steps were needed. One for schema restore and the second for the data. I was surprised as your support offered me a patch for it. Seems that you guys discussed it internally and decided to change the behaviour. So yes now if i restore the table the schema gets restored too. As i've been told it's going to be changed in a future release too.
-
- Veeam Software
- Posts: 21138
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL U-Air issue
Thanks, I just wasn't aware of that. Confirmed, schema will be also restored along with the data.
Who is online
Users browsing this forum: No registered users and 44 guests