Viewing 15 posts - 4,216 through 4,230 (of 9,244 total)
It will be unaffected providing the log doesn't then run out of space afterwards.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 8:18 am
i use a combination of the date last updated and the amount of data modified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 7:26 am
you will never be able to remove the primary data and log files they must always remain.
To remove an unwanted log file use DBCC LOGINFO against the database in question...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2013 at 7:18 am
In that case the create file operations on the principal will put the mirror session into suspended mode. Check this link for details of how to fix this scenario.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2013 at 4:30 pm
As a default, only administrators will have ACLs to read and write files to the root of a drive. Create a folder and give the database engine sufficient permission, then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2013 at 7:28 am
winmansoft (4/8/2013)
1. For each file to be moved, run the following statement.
ALTER DATABASE model
MODIFY FILE ( NAME = modeldev ,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2013 at 7:20 am
First question is
Do the database file paths match on both servers?
So, for instance if the database files on the Principal are located in
D:\MSSQL_10.50.Prod\MSSQL\Data
Does this path exist on the mirror or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2013 at 4:40 am
muthyala_51 (4/4/2013)
I was not able to follow this statement, can you please elaborate--
The key to remember here is how the clustered instances will be distributed, just because you install a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2013 at 3:54 pm
clare.xia (4/5/2013)
but why it has Access Denied error when I used the new master database to start up SQL server?Thanks
You started the instance in single user minimal config mode?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2013 at 3:39 pm
If all the system database files have been wiped out, you cannot start in single user mode as SQL Server expects at least the master database to be present and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2013 at 7:01 am
i find it absurd that you're able to consistently type the password wrong that many times lol
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2013 at 6:41 am
deep_kkumar (4/1/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2013 at 3:48 am
Where does your instance of ssrs look for its databases?
Are you deploying the reports via visual studio or importing via web manager URL?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2013 at 2:41 am
Have you checked the event logs and the cluster events.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2013 at 2:25 pm
The only problem the attach will cause is the part where you open the file browser to locate the log file. The file browser will search for *.mdf and *.ldf...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2013 at 8:56 am
Viewing 15 posts - 4,216 through 4,230 (of 9,244 total)