Recent content by k108

Yes, write a function or stored procedure with your case statement and call the function or stored procedure inline.

Thanks! I had the same problem.

Hi, I see that you can find the date a database was created. However, is there an accurate way to find the date that SQL Server itself was installed? Thanks

Hi MrDenny, As you can tell I don't have much experience with the restore process... however, I have since discovered that everything you said was correct. I didn't know that when you backup a database that it also "includes" the active log file as part of the backup. But I have now verified...

Hi, I am trying to run a CREATE DATABASE command from Query Analyzer. I am getting the following error: " Create database permission denied in database 'master' " Yes, I am trying to run it from the master database. Not sure where else I would run this command... any ideas?? Thanks

Yes, you are correct. I just found out how you would do this: sp_configure read_only Thanks

Yes, I did some more research on BOL, and it DOES appear that STANDBY is the same thing as READ-ONLY. That is, restoring a standby database makes it read only, so that you can query the db between restores (such as 2 log file restores). Read-only is not a thing in and of itself... That is...

Hi, I have been using EM to practice database restores. One of the options available under "Recovery Completion State" is: "Leave database read-only and able to restore additional transaction logs". Is this the SQL equivalent of: RESTORE DATABASE mydb blah blah STANDBY = standby name And if...

Yes, I use the sp_helpdb command a lot. Unfortunately, it does not tell you if a database is in standby mode.

Ok, I think your post is making more sense to me. I guess what fouled me up is the idea that I don't have to restore the logfile along with the datafile. But I just did it in EM, and it does restore the active logfile along with the backup data file.

Really? This doesn't sound right... I am pretty sure you can restore *just* the database... in fact, I am 99.99% sure. Which still leaves me at my original question. If you don't restore the log file, can it be created separately (and therefore empty)? And please understand, I am not trying to...

Hi, Is there a sql statement you can run to determine if a particular database is in standby mode? Thanks p.s. I notice that I am able to run certain queries against my standby database. What can and can you *not* do if a database is in standby?

3.) And what if you DON'T want to restore you logfile?? How does the logfile get created on the target server after you've done the database restore? Thanks

Hi MrDenny, OK, I have some questions for you: 1.) Does the restore have to be from a backup? That is, NOT from the "live" database file? (Sorry if this a dumb question, but not all our databases are backed up, but I still need to restore them to the other server - so do I need to back the...

According to BOL, you apply the logs, not "move" them over: ============================= USE master GO -- First determine the number and names of the files in the backup. RESTORE FILELISTONLY FROM MyNwind_1 -- Restore the files for MyNwind. RESTORE DATABASE MyNwind FROM MyNwind_1...