Good morning,
I am wondering if any of you can give me some help with the practice exercise in the MS Press 70-431 Text, starting on page 671.
I am doing this on my personal PC that runs Vista, and am using the Enterprise Edition that comes on the enclosed CD with the book.
The instructions for the practice are fairly detailed, however, I completely understand all of it. They have you set up a folder off the C drive, then three subfolders, one of which will store the backups, that you name "LSBackup". You also have to make this subfolder "shared" and give "Everyone" permissions.
The configue has you select "Yes, Make a Full Backup, and restore" option. This creates a backup in this shared folder. Then when the process starts to restore the database from this just created backup into one of the other subfolders, the process stops with the following error:
"Cannot open backup device '\HP-PCLSBackupLSTesting.bak' Network path not found Error 53"
Note "HP-PC" is my computer name that I determined in the System icon in Control Panel. "\HP-PCLSBackup" is the network path name entered in one of the text boxes in the exercise.
I tried doing a regular restore of the backup file above, using the right click menu and referencing the file via it's path name:"c:LogShipPracticeLSBackupLSTesting.bak"; and restoring the DB into the other folder and it works fine.
The LSBackup share folder shows on Windows Explorer off the Network Node.
Go easy on me guys, I am not a tech support/engineer... I do systems development work. I may have missed something obvious to many of you somewhere along the line.
There is a MS Press book that I read which used the following code to prevent SQL Injection attempts from succeeding within a SProc. However, I have found that this example is too inclusive. For example, this will catch the value "Spanish Moss", when this clearly not an injection attempt. Why is that?
IF UPPER(@Query) LIKE UPPER(N'%0x%') OR UPPER(@Query) LIKE UPPER(N'%;%') OR UPPER(@Query) LIKE UPPER(N'%''%') OR UPPER(@Query) LIKE UPPER(N'%--%') OR UPPER(@Query) LIKE UPPER(N'%/*%*/%') OR UPPER(@Query) LIKE UPPER(N'%EXEC%') OR UPPER(@Query) LIKE UPPER(N'%xp_%') OR UPPER(@Query) LIKE UPPER(N'%sp_%') OR UPPER(@Query) LIKE UPPER(N'%SELECT%') OR UPPER(@Query) LIKE UPPER(N'%INSERT%') OR UPPER(@Query) LIKE UPPER(N'%UPDATE%') OR UPPER(@Query) LIKE UPPER(N'%DELETE%') OR UPPER(@Query) LIKE UPPER(N'%TRUNCATE%') OR UPPER(@Query) LIKE UPPER(N'%CREATE%') OR UPPER(@Query) LIKE UPPER(N'%ALTER%') OR UPPER(@Query) LIKE UPPER(N'%DROP%') BEGIN RAISERROR(N'Possible SQL injection attempt.', 16, 1); RETURN; END ELSE BEGIN PRINT N'All is well!'; RETURN; END
If I remove "Spanish" from the query, or the check for "sp_" from the IF statement, this runs fine. So I know the line where this is caught, but it doesn't make sense to me. I can also duplicate this using the work "experienced" which gets caught by the "xp_" check.
I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.
Can we switch database recovery model when log shipping is turned on ?
We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.
I 'm sure I am missing something obvious, hopefully someone could point it out. After a failover log shipping, I want to fail back to my inital Primary server database; however, my database is marked as loading. How can I mark it as normal?
I did the failover as follow:
I did a failover log shipping from the 2 server Sv1 (Primary) and Sv2 (Secondary) by doing the following
1) Stop the primary database by using sp_change_primary_role (Sv1)
2) Change the 2nd server to primary server by running sp_change_secondary_role (Sv2)
3) Change the monitor role by running sp-change_monitor_role (Sv2)
4) Resolve the log ins - (Sv2)
5) Now I want to fail back - I copy the TRN files to Sv1 - use SQL Ent to restore the database at point in time. The task is done; however, the database is still mark as loading. I could not use sp_dboption.
For those of us struggling with DTS, you've probably all seen Professional SQL Server 2000 DTS Mark Chaffin, Brian Knight, and Todd Robinson WROX ISBN 1-861004-41-9
This is brand new: Microsoft SQL Server 2000 DTS Timothy Peterson SAMS ISBN 0-672-32011-8
I have both and they're both worth owning.
I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...) Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS Frank Miller & Rachelle Reese WROX ISBN 1861002807
I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:
Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.
Hi, Can you recommend a book on SSIS. I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters. Thanks
Hi I tried to download the E-Book that is located on the benefits page, when i click to save it to hard drive it just sits and nevers start the process. What can I do to correct this matter. Thank you for you time and effort.
I'm looking for a good book to teach me the basics of SQL Server DBA - installing, daily routine tasks, basic best practices, etc. I'm a DBA newbie so I want beginning level.
hello i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
I'm looking for a book or a couple of books to learn SQL (in general aswell as various versions from different vendors). A couple of books that would take me from beginner through advanced topics. Any good suggestions?
Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.
Hi All, I am new to SQL Server but have been doing database programming since last 3 years. I recently attended MOC (Microsfot Official Curriculum) training on SQL Server and have started to use at my company. I am comfortable with SQL but want to dig deeper into T-SQL side. I searched on the Internet but not many good books available in that either they are ranked very low or are very old i.e. written around 1999/2000 or covers SQL Server 2000 as a whole. Can anybody suggest me any T-SQL book which was written recently and focuses purely or majorly on T-SQL?
Thanks to all for your time and advice in advance.
Can anyone recomend a really good text book on sql Server. Something that gives alot of useful code for real world apps. But also needs to easy to understand.
I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!
I have bought this book called " The complete reference guide to SQL'. I'm trying to read throught it etc, however it brings a cd with the sample db that is used through out the book, it mentions that you can load it and use it to practice..........however all the files are in .DAT format and I have no idea how to load it into SQL server 2000 :(
Ok, let me start by saying that I already checked the FAQ. There was one link, but it just seemed to go to a review page with 5 books, with pretty specific themes. So I'm surprised that such a basic topic as book recommendations for SQL newbies wasn't covered.
In my case, I'm not a total newbie. I learned to write SQL queries for work on both Oracle and SQL Server, and I've gotten pretty good at all the basics. So I've got "SQL for Dummies" down cold, so to speak. Now I'm looking to take my query writing ability to the next level, which I guess would be the intermediate level. I'm also looking for books that are specific to just SQL Server, rather than the books about general querying on any DBMS. Speaking of which, just so you all know, "SAMS Teach Yourself SQL in 21 Days" is an Oracle book, no matter what it says on the cover.
It looks like the book "Inside Microsoft SQL Server 2005: T-SQL Querying" comes highly recommended, but I flipped through it on the shelf at a bookstore the other day, and I think it's over my head. It might be a good reference to have around, but I think I'd be totally lost trying to read it from cover to cover.
So does anyone have recommendations for books that go beyond "This is how to do a SELECT, and here's how to do a JOIN", but won't make my head explode?
I do software support for software that works with both Oracle and SQLServer, so I mostly just write queries to look at the data related tothe software. When I first started, I bought a couple of books to learnthe basics, intentionally going with generic books that would help withboth types of databases. I've got the basics down, and now I'm lookingfor a really detailed reference book that goes really indepth intoquerying for SQL Server specifically. Currently, we only work with the2000 version, but we'll be going to 2005 soon, so I think I'd rather gowith a book on 2005, although if you know one that covers thedifferences between them, that would be great. Any recommendations?Besides just writing queries, I'd also like to learn more about SQLServer in general. DBA software support, so I'd like to head mycareer in that direction. I was looking at Microsoft's newcertification path for SQL 2005. Given that my company won't pay tosend me for training, and I really don't want to have to put down$2200+ to pay for a class, I was thinking that I might be able to learnenough on my own to pass the first test and get the MCTS title. Iordered the Training Kit from Microsoft Press for that, which comeswith a 180 day trial of SQL Server 2005 to play with, along with a hugebook. Does anyone have any other recommendations for resources to helplearn this stuff?--Richard
