Viewing 15 posts - 46 through 60 (of 83 total)
With mixed mode, you can authenticate with either kerberos (Windows) or SQL. SQL holds a list of logons and passwords which is used to authenticate logon requests. SQL authentication does...
October 28, 2009 at 9:23 am
krypto69. SA access is granted at the server/instance level and affects all databases.
In SSMS,:
* Connenct to the SQL
* Expand Security then Server Roles
* Open sysadmin
This gives you who have SA...
October 28, 2009 at 9:15 am
Reading books on line would be a help. See the bold bit below.
In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine...
October 28, 2009 at 8:37 am
You can always script the table creation, run this script on the other server and use "insert ... select * from server.schema.object. :w00t:
It's dirty but yet another option. 😎
October 28, 2009 at 8:29 am
Hi.
Providing you have correctly changed the location settings for TempDB, this will move when you fail over.
From experience, stopping and restarting the SQL Server resource is much faster then...
October 28, 2009 at 2:26 am
TheSQLGuru (10/27/2009)
Good stuff to point out Mark!
One minor point is that I think it is best practice to have no actual user objects/data in the PRIMARY file group....
October 27, 2009 at 4:10 pm
You can also get a performance gain regarding backups and restores.
If partitioned tables in your PRIMARY filegroup only hold 6 months of data, your filegroup backup may only take 2...
October 27, 2009 at 2:54 pm
UncleBoris. To backup and restore a database, use the following.
Backup your database using backup database ... command. That's all you need to do.
Next, restore your database to the test server...
October 21, 2009 at 5:13 pm
Grasshopper.
You are right in your assumption that you cannot shrink a file below its initial size but you can reclaim the space by moving objects between file groups. I've not...
October 15, 2009 at 1:46 pm
Of course!! As the LSNs match, the logs will apply.
Good call Captain!
October 9, 2009 at 1:47 am
Ian Scarlett (10/8/2009)
You then have your DR database in read only mode, and you can run as many queries as you want to prove that the restores have been working....
October 8, 2009 at 2:58 pm
Some times you win, some times you loose. I use to run daily backups and log ship a 1T database but requirements vary.
Can you not run a test restore on...
October 8, 2009 at 8:39 am
Monthly Fulls and daily Diffs ... Ouch! :hehe: Take diffs in between daily backups by all means but ...
Personally, I would be looking at daily full backups with weekly Fulls...
October 8, 2009 at 7:45 am
Hi John.
I am assuming that the monthly restore is to prove that the backups actually work. If this is the case, gold star to the client. If not, perhaps you...
October 8, 2009 at 5:42 am
Mani-584606 (10/7/2009)
Having Single Backupgroup and creating 3 fileshare resuorces on that backup drive for 3 instances and configure log shipping does not work in all scenarios right?
Log shipping works fine...
October 7, 2009 at 1:51 pm
Viewing 15 posts - 46 through 60 (of 83 total)