|
I think you're right, but unfortunately I can't get access to the DB myself, and the others who have access know nothing about databases except how to follow instructions from a phone support desk. I suspect that it would take me about 20 minutes to solve this if they'd let me in.
I actually found it using Management Studio from my desk, but it won't let me log in...
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
If you can't do anything about it, it is not your problem.
Whatever becomes impossible due to the situation will result in a consistent "can't do that due to database problems" reply. It will sort itself out eventually. Even management gets in check with reality on occasion.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
If there is no room to create the log of the transaction then you can't execute any transactions that would require logging (with is everything be default). So you would have to do some more drastic things like truncating tables using the with nolog hint to prevent logging. Or you free up space in the transaction log. Shrinking Transaction log[^]
It isn't from Metretek is it? If so, do they still use the ridiculous 60 hourly columns table format for meter reads
|
|
|
|
|
Nope - It's Hunt Technologies/Landis & Gyr Command Center. When it was TurtleWare I could make it jump through hoops on command, but since the upgrade I've been kept away from the details.
It would have been nice of them to include a warning about the space remaining in the software they provided...
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Roger Wright wrote: It would have been nice of them to include a warning about the space remaining in the software they provided...
It's actually called gross incompetence and should be punished - terminally.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I agree, but we already have rather a lot invested in meters, and these systems are very proprietary; we can't change vendors without replacing every electric meter in the system.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Roger Wright wrote: Does SS2003 lock everything once it hit its hard-coded limit?
SQL Server - NO.
SQL Server Express/CE/MSDE - YES (at 4 gig).
Perhaps you need to migrate from SQL Server Express to the full version.
|
|
|
|
|
That seems to be what's installed, since it has locked itself. Tech Support claims to have a fix, but coincidentally, we just received a new server and they want to install it there. Since we have to read meters on Thursday, this might get interesting. Happily, I'm on vacation next week so it won't be my problem.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Hi All,
This is the code i am running..
BACKUP DATABASE [Outbound_Vodafone]
TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'
WITH DIFFERENTIAL , INIT
This path is already shared to my domain user login.
But I am getting this exception..
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Please help!!
Regards,
Amandeep Singh
|
|
|
|
|
Which version are you using (it looks like one of MS SQL). If you are using SQL 2000 you may not be allowed to backup to a different system.
|
|
|
|
|
I am using SQL server2005!!
|
|
|
|
|
Have you try this?
BACKUP DATABASE DatabBasename
TO DISK = 'C:\BackUp\databasenamebackup.bak'
WITH FORMAT;
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Please understand i want to take backup's on some other server, not on the local.
|
|
|
|
|
Instead path of localhost give path in which you are trying to backup database.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
That's what i am doing dear!
See the
BACKUP DATABASE [Outbound_Vodafone]
TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'
WITH DIFFERENTIAL , INIT
but it's not working.
|
|
|
|
|
I really don't know much about this, but the access denied message suggests the backup is trying to do something on that disk that is restricted by permissions. You say that this disk is shared to your login, but are you sure that you have full access control on it; can you read and write and create directories etc?
It's time for a new signature.
|
|
|
|
|
Sometimes I have the same problem on some clients servers.You need to ensure that the account, SQL server is running under, has the appropriate access rights to the shared network partition. .
[EDIT]
I'm not sure but I suppose that SQL server should better be running under Network service built-in account.
[/EDIT]
Life is a stage and we are all actors!
modified on Tuesday, May 25, 2010 4:46 AM
|
|
|
|
|
Hristo Bojilov wrote: I'm not sure but I suppose that SQL server should better be running under Network service built-in account.
I believe that is the problem. I had an issue where the account running the SQL Server Agent did not have the permissions to access the other server. I changed the account but I think there is a way to impersonate for a run. Sorry I have not used this but seem to remember reading in a study guide.
|
|
|
|
|
still not get any appropriate answer.. Kindly add some more solutions.
|
|
|
|
|
Hey,
I am just wondering whelther we can generate the sql query if we already have tables. Just curious about that. If yes, how to do it ??
suchita
|
|
|
|
|
What kind of queries are you looking for? Management Studio 2008 does provides the basic structure of the statements fora table.
|
|
|
|
|
like i created one table. lets say
S.N | Name | PhoneNumb|
Now this S.N is auto increment. I am testing my project and I need to reset table many times and since this S.N is auto increment, its value just kept on increasing. So what i'm doing is just deleting the table and re-creating the table manually. So i am just wondering that if i can generate the "create" sql query for the already existed table, then once i delete that table, i can re-run that create query to create that table again. Well I can write the query and re-run it. Thats not the problem but i am just checking if there is any that feature in sql server ??
suchita
|
|
|
|
|
How are you performing the testing? If you are using test projects, make use of TestInitialize and TestCleanUp methods to clean the data up from the tables used.
|
|
|
|
|
|
Your TestCleanUp method should execute the script to clean the tables from the database.
|
|
|
|