SQL server exams - data file space

Author

data file space

naresh_sky

2002-11-15, 4:19 am

hi to all.

well my problem is that

what happens if the datafile(.mdf,or.ndf)
grows above the maximum space allocated.

what happens in a scenario where i use a
windows login mode i delete the login user
and he has some tables(objects) created in
sql server.

expect that i am a database admin i lost
my password and i want to login to the
sql server how can i retreive.

hope u solve my problems

naresh

naresh_sky

2002-11-16, 4:37 am

come on guys help me out please

thanks
naresh

2lazybutsmart

2002-11-16, 8:26 am

well first question first.

a db either has a restricted filegrowth specified in the MAXSIZE attribute, or is unrestricted. a db can never grow above the limits. what grows are rows, and they don't span pages, but they are splitted in half so that enough space is left for new data.

secondly. a user is the owner of any object he/she creates. by deleting the user, any objects created by the user are left intact. since dbo is the default owner of all object in the database (since he's the db owner), ownership is transferred to him.

and finally, if ur username is "sa", then you'll have to reinstall the server. if it's another username, simply log-in as sa, delete your user, and then create it again.

cheers,
2LBS

naresh_sky

2002-11-19, 5:46 am

thanks 2lbs..

your r great.

but i didnt get convinced with your answer

the first one you said the database wont grow but how come it wont .
my question was if u dont have enough space on your file and you want to insert the rows
then what happen to the database...

the second one was Ok and thanks.

the final one (third) you said i need to reinstall the sql server if i dont have the
password for sysadmin is this the only way
is there no other way to regain the password

thanks for your help
naresh

2lazybutsmart

2002-11-19, 6:46 am

well, this time last question first.

Don't confuse the 'sa' username with other usernames. this is the user that has all rights and privelages in SQL Server. If the password is lost for 'sa', then there is no way to recover it whatsoever. This is how M$ does it, we gotta abide by it.

Next. I did not say the database won't grow. It will eventually. But it won't grow above the limit.

For example. A DB's initial size is 10 MB. And it's MAXSIZE (the maximum size it can gorw) is set to 15 MB. Get his point clear. The size of the DB is not 15, it's 10. But it's allowed to grow upto 15. Clear?

Now, if you put in 10 MB of data into you DB, then that's fine. If you put in 1 MB more, then that's still fine. as the DB's size will be increased to 11 MB. 2 more MB's, fine. upto 5 more MB's is fine. then the database is 15 MB. YOU CAN NOT grow more than that becuase 15 MB is the limit.

Just shout out for more
cheers,
2lazybutsmart

naresh_sky

2002-11-20, 5:21 am

thank's 2lbs.

buddy you r really cool .
tell u what you r absolutely gem of a
person.

anyway thanks once again for your support

thanks
naresh

Sponsored Links