1

Topic: Export from Master table

Hello,
Help pozh to understand.
Created and when that launched basis, but all tables why that pushed in the Master system basis.
Now lifted new basis, on other server MS SQL 2008, and how to me the data here ?
Between servers there is no communication, and the data in them it is a lot of tables.
Thanks.

2

Re: Export from Master table

hulk;
I am direct I neigh in a voice smile
If volumes are not huge,  tables and interpose in your new

3

Re: Export from Master table

hulk wrote:

Created and when that launched basis, but all tables why that pushed in the Master system basis.

... Whether the Express train it is casual?
At it a limit on data size in  bases.
Here could and push all in the master that terabytes there to store

4

Re: Export from Master table

hulk;
And if to try to make  the master and to recover under other name?

5

Re: Export from Master table

TaPaK;
It as, Save Pastom ?)))

6

Re: Export from Master table

o-o wrote:

it is passed...
... Whether the Express train it is casual?
At it a limit on data size in  bases.
Here could and push all in the master that terabytes there to store

Is not present not .

7

Re: Export from Master table

Massa52 wrote:

hulk;
And if to try to make  the master and to recover under other name?

I am am brought by storage.
We did it and considered here at a forum.
Whether , whether attachili/detachili the second master.
This second master all the same for the master does not consider the server, at reversal to the circuit sys in the left master
Readdresses in the real master.
But here it seems to me, versions of servers were identical.
And at it different, and whether it can  the left master, the science does not know.
But why not to try

8

Re: Export from Master table

Yes is not present, all is good with storage.
Here this subject:
Saving of the size of basis
In general, with 2008 on 2012 it was not possible to transfer because of unfortunate ;
It was normally transferred with 2008 on 2008.
In general, it is necessary to check
to hulk
Well and it is good, what not the Express train.
Means, it is possible and not in the master to transfer.
To begin with try bekap/restor, suddenly carries.

9

Re: Export from Master table

o-o wrote:

yes is not present, all is good with storage.
Here this subject:
Saving of the size of basis
In general, with 2008 on 2012 it was not possible to transfer because of unfortunate ;
It was normally transferred with 2008 on 2008.
In general, it is necessary to check
to hulk
Well and it is good, what not the Express train.
Means, it is possible and not in the master to transfer.
To begin with try bekap/restor, suddenly carries.

Thanks., I will try to understand, considering that I at all the administrator, but the task on me.
To me therefrom  entirely everything, and in new it is already possible to write down tables in new basis.

10

Re: Export from Master table

o-o wrote:

yes is not present, all is good with storage.
Here this subject:
Saving of the size of basis
In general, with 2008 on 2012 it was not possible to transfer because of unfortunate ;
It was normally transferred with 2008 on 2008.
In general, it is necessary to check
to hulk
Well and it is good, what not the Express train.
Means, it is possible and not in the master to transfer.
To begin with try bekap/restor, suddenly carries.

Was, a test subject.

11

Re: Export from Master table

hulk wrote:

considering that I at all the administrator

It in sense of an honorary title or in sense of the rights?
   basis;
To the server all the same on whom the task, it checks the rights.

12

Re: Export from Master table

o-o wrote:

it is passed...
It in sense of an honorary title or in sense of the rights?
   basis;
To the server all the same on whom the task, it checks the rights.

smile)). Is not present considering that business not mine and me to rake. I last MS SQL 2000 saw I remember.

13

Re: Export from Master table

Hupin wrote:

Was, a test subject.

Yes, what times were.
And servers I had a whole zoo on ;
And  at us terminal sessions and even USB-inputs are chopped off.
Even reading matter to myself I can not bring;
It is necessary to rummage to itself on the Internet from the house and to swing on operation 8-o

14

Re: Export from Master table

o-o;
Worked in such place where ostensibly USB-inputs are chopped off.
Found out that administrators disconnected them for a long time already, on old computers in department.
And about new nobody thought. Imperceptibly used, that neighbors did not envy.

15

Re: Export from Master table

Eleanor;
Thanks for idea.
But not .
We only moved.
All terminals new.
And generally all new.
In the first week after moving the bidet fell off in. A toilet.
They it on glue , any person flopped, the bidet and fell off.
So delivered all angry letters with a subject
"Acts of vandalism in a new building".
In the end an addition: even do not think, to an old building we do not return all the same.
It is type someone specially tore out this bidet in protest at moving, absolutely already ...
And then, I do not take a word to anybody;
And always personally I check.
.
Unless new administrators of the server it is better nothing old;
Here such here a unique consolation

16

Re: Export from Master table

All Thanks.
With  indirect application exported in Aksess, the blessing kind people helped.
And then Iport in new basis, and not in the Master)))

17

Re: Export from Master table

hulk;
It is not pleasant to me (usage of Aksessa).
Data types can not coincide and as in this case the data    the big-big secret.

18

Re: Export from Master table

Well, companions.
normal master 2005 on 2008 the server.
And  without problems.
"System " only does not allow to delete;
Because climbs in the real master.
Well and so, all is good

19

Re: Export from Master table

Eleanor wrote:

o-o;
Worked in such place where ostensibly USB-inputs are chopped off.
Found out that administrators disconnected them for a long time already, on old computers in department.
And about new nobody thought. Imperceptibly used, that neighbors did not envy.

Strange at you any administrators.
We disconnect USB Kaspersky's policy, aimed at specific users, and any problems.
To whom it is necessary - have, to whom it is necessary - is not present.
On all domain computers, automatically.

20

Re: Export from Master table

o-o;
dbcc checkdb (master_2005)?

21

Re: Export from Master table

iii2;
It was some years ago, and it was the bank.
All stories about low qualification in banks there turned out to be true: my predecessor did not know that such GROUP BY. Generally developers knew only 2 isolation levels read committed and read uncommitted.
But at them was excellent servers and , in my current office and now to itself such cannot allow.

22

Re: Export from Master table

asgfl wrote:

o-o;
dbcc checkdb (master_2005)?

[spoiler]
MessageText
Check Catalog Msg 3851, State 1: An invalid row (class=60, depid=1, depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=1,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
Check Catalog Msg 3851, State 1: An invalid row (class=60, depid=2, depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Check Catalog Msg 3851, State 1: An invalid row (class=60, depid=3, depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Check Catalog Msg 3851, State 1: An invalid row (class=60, depid=4, depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Check Catalog Msg 3851, State 1: An invalid row (class=60, depid=5, depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=257,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=258,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=259,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=260,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=263,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
CHECKDB found 0 allocation errors and 11 consistency errors not associated with any single object.
Page (1:10) in database ID 5 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags ' MIXED_EXT ALLOCATED 0_PCT_FULL '.
CHECKDB found 1 allocation errors and 0 consistency errors in table ' (Object ID 99) ' (object ID 99).
CHECKDB found 1 allocation errors and 11 consistency errors in database ' master_2005 '. [/spoiler]
It on the empty master
(The first bekap-restor was on . without  tables)
Today specially for purity of experiment the master of 2005 contains  the table.
transited all as well.
checkdb produced exactly same 15 lines.
So  kindly it is not touched.
Well and checkout  fulfilled without errors.
So  the data as it should be also can be transferred somehow to adjacent basis.
---
dbcc checkdb (master_2005, repair_allow_data_loss)
Repairs only allocation error, 11 consistency errors remain.
Well and unnecessary , besides.
Therefore, all over, better given to pour;
At least types will be saved, with identity it is possible to understand etc.
And that there for a grass passed through a horse basis, passed through , it turned out;
The science does not know

23

Re: Export from Master table

iii2 wrote:

it is passed...
Strange at you any administrators.
We disconnect USB Kaspersky's policy, aimed at specific users, and any problems.
To whom it is necessary - have, to whom it is necessary - is not present.
On all domain computers, automatically.

Pribluda Kaspersky it is forbidden in many organizations.

24

Re: Export from Master table

Hupin wrote:

it is passed...
Pribluda Kaspersky it is forbidden in many organizations.

Carries to you.
In the Russian Federation - it [practically] everywhere is mandatory, since only it has all possible certificates.
... However, not a flame for, it really best [Russian] antivirus.

25

Re: Export from Master table

iii2 wrote:

only it has all possible certificates

The certificates necessary to us (protection of personal data) are still at Dr Web and Eset. Together with Kaspersky it is 3 "Russian" antiviruses.