Search results for query: *

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...

Hi DrSql, Yes, I decided that I need to do a restore. And actually your code does help me, because I was wondering how the LOG get created on the target server. How does this work if the LOG file is in use? Also, I don't know if I actually want to copy the existing log file over... I just...

Hi, I am restoring a database to a new server. I just read that if I use the "WITH MOVE" clause for the restore, then I don't have to create the databases first. But what do I do about the logfile? Does this get created automatically as well? I ask because I WAS in the process of creating...

I don't have the option of detaching the databases, as they are part of our production server. Nor do I think this is what I want to do. I don't want to MOVE the original database. I simply want a COPY of the database on another server.

I apologize in advance if this is an obvious question. I need to copy or restore (haven't decided which yet) four databases from SERVER A to SERVER B. So, my question is, should I use the Database Copy Wizard, or should I restore the databases to SERVER B using a backup? Is there any...

Ok, this may seem too obvious, but would the autogrowth % have been too big for the existing free disk space? That is, if it autogrew, would it have taken up more than the available disk space, given the autogrowth %?