August 10, 2010 at 3:18 am
BrainDonor (8/10/2010)
webmaster 27466 (8/10/2010)
He just up and left.Now I am stuck with what I've been left to work with.
Webmaster, I did you a disservice - I assumed you were one of the many people that becomes a DBA under false pretences. My apologies - being dropped in it like that is no fun at all.
BrainDonor.
your apology is accepted.
I was originally just the NSA(Network Security Administrator) however now as you can see I've been dropped into an additional job for who knows how long. The company I work for told me to learn how to make this work and I've got everything set up(remote database, etc) but I have been frantically trying to find how to retrieve the actual changes.
I've tried entire dumps and comparing them beginning and end of day, this works however with such a large datbaase it takes a very long time.
Finally I was referred here, so this is pretty much my last hope.
August 10, 2010 at 4:26 am
Someone please help me, I have 6 hours and I am running out of time.
I would greatly appreciate it.
August 10, 2010 at 4:30 am
The people that have asked you to do this are going to have to understand that in your situation you'll need time to learn and practice these things.
A description of the Transaction Log File:
http://www.sqlservercentral.com/articles/64582/
And an example of Log Shipping:
http://msdn.microsoft.com/en-us/library/ms190640.aspx
SQL Server Management Studio is the main tool to use for both of these aspects (selecting the Recovery model, scheduling backups, Log Shipping and a good deal more).
Apart from trawling the Internet a couple of books I've used are "Professional Microsoft SQL Server 2008 Administration" by Wrox and "The Real MCTS SQL Server Exam 70-432" by Syngress, which includes basic example of various replication scenarios.
BrainDonor.
August 10, 2010 at 4:35 am
ODPOA (8/10/2010)
Someone please help me, I have 6 hours and I am running out of time.
We're all volunteers here, we all have our own jobs, we're all posting in our spare time. I know you're under time restrictions, but we can't just drop everything and help.
Now, you posted in the SQL 2008 forum, so you're using SQL 2008? Do you have management studio installed (on a windows machine)? If not, can you locate the SQL 2008 installation disk and install it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2010 at 4:47 am
Thank you all for your help.
I did not mean to make it seem as if I expect your help, it however seemed for a moment as if you had dissapeared, and I am on a time limit running short.
I am currently running MSDE Microsoft SQL Server Desktop Engine.
Most likely a very old engine.
I will proceed to backup the database and install 2008 along with the management studio, I guess my main question here is just to be clear what exactly do I click to get into the menu to create these logs?
After I am able to log the queries I am sure I will be able to work fine from there.
August 10, 2010 at 4:52 am
ODPOA (8/10/2010)
I did not mean to make it seem as if I expect your help, it however seemed for a moment as if you had dissapeared, and I am on a time limit running short.
Well I do have my own job to do.... (I'm a consultant so time spent here is time I'm not billing)
I suggest that you speak to whoever put that deadline in place and inform them that you don't know much about SQL and hence are going to need more time to figure things out.
I am currently running MSDE Microsoft SQL Server Desktop Engine.
Most likely a very old engine.
SQL 2000, and a very limited version of SQL 2000 as well. I don't even know if SQL Agent is installed. That's going to be hard to work with
I will proceed to backup the database and install 2008 along with the management studio,
Don't bother. You need the SQL 2000 client tools, and I have absolutely no idea where you'll be able to get Enterprise manager from.
After I am able to log the queries I am sure I will be able to work fine from there.
If you want log shipping, there's not logging of queries involved. There's database backups and transaction log backups. No queries. I strongly suggest that you hit MSDN and read up on log shipping.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2010 at 4:53 am
I have reviewed this information and I should be more than able to carry out the necessary step.
Thank you so much for your help.
August 10, 2010 at 4:56 am
Could this not do the trick... for now?
http://www.microsoft.com/sqlserver/2008/en/us/express.aspx
along with this.
?
If you dont mind me asking, why do I NEED the 2000 tools?
August 10, 2010 at 5:03 am
ODPOA (8/10/2010)
Could this not do the trick... for now?http://www.microsoft.com/sqlserver/2008/en/us/express.aspx
along with this.
?
You can try, but I don't know if the SQL 2008 client tools can set up log shipping on SQL 2000. I doubt the express tools can, because they lack SQL agent (not that I event know if MSDE has SQL Agent) and you need the agent to do log shipping - the schedules.
I'd honestly suggest that you see if management can get someone in to help out with this and to train you at the same time.
If you dont mind me asking, why do I NEED the 2000 tools?
Because MSDE is SQL 2000. It's the free (and very limited) version of SQL 2000. To properly admin and configure SQL 2000, you really need the SQL 2000 client tools.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2010 at 5:17 am
I was planning on upgrading the database and tools to 2008 express edition along with upgrading soapware to the 2010 version.
This would at least allow updated functionality, something easier to work with.
And perhaps if log shipping is not "included" if I read correctly I could simply keep the Transaction Logs around long enough to make copies of them on the remote server's drive and use Full Recovery model, then write a program to automatically process everything from there.
Does that sound plausible?
August 10, 2010 at 5:20 am
GilaMonster (8/10/2010)
ODPOA (8/10/2010)
Could this not do the trick... for now?http://www.microsoft.com/sqlserver/2008/en/us/express.aspx
along with this.
?
You can try, but I don't know if the SQL 2008 client tools can set up log shipping on SQL 2000. I doubt the express tools can, because they lack SQL agent (not that I event know if MSDE has SQL Agent) and you need the agent to do log shipping - the schedules.
I'm pretty sure that Gail's correct. 2000 was made before 2008 and therefore cannot read some of the datatypes 2008 includes. So attempting to ship a file that has differences in datatypes would probably blow up in your face.
What I'm confused about is your insistence on logging queries as part of your backup. What is it about the queries you're trying to log? The actual code used to pull / insert data or the actual data in the database?
That makes a difference on what we recommend for you.
August 10, 2010 at 5:24 am
I would LIKE to log the actual code, but that doesnt seem possible.
August 10, 2010 at 5:30 am
ODPOA (8/10/2010)
Backing up ALL changes is relevant as the data is important and all relevant to other data elsewhere in the database.Also I have looked I dont see any option for this.
I have scheduled a daily backup but I dont want to backup the WHOLE database every day, just the changed to it.
I'm going to answer this particular post as if I haven't read the rest of the thread.
Look into FULL and Differential database backups. Google these phrases: "SQL 2000 database backups", "SQL 2000 FULL Backups", "SQL 2000 Differential Backups".
Differential backups back up the changes since the last FULL database backup. You always have to have a FULL backup to start off with, though.
I can't tell if you're trying to set up a disaster recovery scenario or if you're trying to upgrade your database. Or if you're trying to do both. If the last option, then I suggest you work on upgrading your DB first, then look into DR solutions once you're on 2008 express.
But, as others have repeatedly said, talk to mgmt to get training because you don't have time for either. No properly planned upgrade or DR solution can be completed (from planning to implementation) in less than 24 hours. It's just not feasible. Not if you want your solution to actually work without problems.
If I'm misunderstanding what you're trying to accomplish here, I apologize. Your statements about recording queries really throws me.
August 10, 2010 at 5:33 am
ODPOA (8/10/2010)
I would LIKE to log the actual code, but that doesnt seem possible.
This is part of our confusion. Logging the actual code has nothing to do with backing up databases.
You can use Microsoft's Profiler tool (which is easier for beginners that figuring out the server-side trace, but also consumes more resources) to log the queries. You'd run your trace over a certain period of time, collecting this information. Then you can replay the trace against a restored database to troubleshoot performance problems or get a baseline of how the database is working.
What do you intend to do with the code after you have it?
August 10, 2010 at 5:39 am
ODPOA (8/10/2010)
I was planning on upgrading the database and tools to 2008 express edition along with upgrading soapware to the 2010 version.
You can, but bear in mind that Express doesn't have SQLAgent (so no scheduling unless you use the windows scheduler) and is limited to a 4GB database.
I would LIKE to log the actual code
Why? It doesn't make sense to log all the queries when all you want a copy of the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 16 through 30 (of 38 total)
You must be logged in to reply to this topic. Login to reply