Viewing 15 posts - 3,001 through 3,015 (of 9,253 total)
GilaMonster (9/2/2014)
Perry Whittle (9/2/2014)
jamessdba (9/2/2014)
3) In BulkLogged can we take Point in time recovey?You don't, they're not supported
You can. It depends on whether or not there's been a minimally logged...
September 2, 2014 at 10:14 am
have you executed all the queires i supplied above, it looks like you havent ran
exec sp_delete_log_shipping_primary_database
@database = 'database'
September 2, 2014 at 7:24 am
jacksonandrew321 (9/2/2014)
Hi FolksWhere would i find my particular database Error log file, Event log file and Trace file etc?
Thanks
SQL Server log you will find in the dump directory for sql...
September 2, 2014 at 5:09 am
mr_belpitt (9/2/2014)
Perry Whittle (9/2/2014)
mr_belpitt (9/2/2014)
sp_change_users_login 'update_one', 'the_username', 'the_username'Substitute "the_username" for your actual username.
Don't take this for granted, the server login and database user won't necessarily have matching names.
It's possible to...
September 2, 2014 at 4:30 am
Generally you'd remove the secondary information first, especially if you plan to re use the primary config 😉
September 2, 2014 at 4:26 am
jamessdba (9/2/2014)
1) If principle server down what willl happen to Mirror DB & Transactions
Depends, if you have a witness and the session loses quorum with the mirror the principal will...
September 2, 2014 at 4:16 am
Chowdary's (9/2/2014)
when i was configured the logshipping the server IP address was 192.168.0.xxx ,And I configured Logshipping successfully.
Now the ip Address was changed to 192.168.0.yyy for some security purpose...
September 2, 2014 at 4:07 am
Tail log is taken using the following (assuming the db is online and undamaged)
Backup log db1
to disk='c:\myfolder\Taillog.trn' with norecovery
If the database is damaged you could use
Backup log db1
to disk='c:\myfolder\Taillog.trn' with...
September 2, 2014 at 3:59 am
the actual share will be \\W2K8SQLBACKUP\SQLBackup and not \\W2K8SQLBACKUP\SQLBackup\wslogdb70_28.
Check the permissions at the share level and also the NTFS permissions too on the subfolder wslogdb70_28.
Check the account that sql agent...
September 2, 2014 at 3:48 am
check the logs for storage related errors, you may well find there related errors being reported
September 2, 2014 at 3:43 am
mr_belpitt (9/2/2014)
sp_change_users_login 'update_one', 'the_username', 'the_username'Substitute "the_username" for your actual username.
Don't take this for granted, the server login and database user won't necessarily have matching names.
It's possible to have a login...
September 2, 2014 at 3:10 am
krishnaprasad_mt (8/31/2014)
Please help me with a SQL query to understand the names of all the available tables , number of records in these tables and size of...
September 1, 2014 at 9:32 am
Ratheesh.K.Nair (8/29/2014)
Hi Experts,How can we check whether all users in Always On primary is there in Secondary with all the access?
TIA
Not entirely sure what it is you mean, but if...
August 29, 2014 at 5:41 am
Pablo Campanini-336244 (8/28/2014)
1.- Can I set up Always-On in both servers?. and have 1 or 2 databases with Always-on?
No, requires a Windows Server Failover Cluster
Pablo Campanini-336244 (8/28/2014)
August 29, 2014 at 2:22 am
PearlJammer1 (8/28/2014)
We use replication...
August 28, 2014 at 8:54 am
Viewing 15 posts - 3,001 through 3,015 (of 9,253 total)